Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
I have jus now created a virtual directory and hosted my web application in iis 6. in my application i am using a login page,.the problem is it is not connecting to the database. what setting should i do to connect to the sql 2008 database.Help me friends...
<connectionStrings>
<add connectionString="Data Source=(local)\SQLEXPRESS;Initial Catalog=ISSUserReigistration;Integrated Security=True" name="ISSUserReigistration"/>
	</connectionStrings>
	
 
This is the code i have used in my web config for connection string. I m using sql2008 r2.it supports windows authentication only.help me what to do for this configuration..
Posted 9-Aug-12 19:38pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Set identity as windows user who have permissions to database.
 
To know how to set identity,
 
check this.
 

http://technet.microsoft.com/en-us/library/cc771170%28v=ws.10%29.aspx[^]
 
http://msdn.microsoft.com/en-us/library/aa289855%28v=vs.71%29.aspx[^]
 
also read
 

 
http://msdn.microsoft.com/en-us/library/bsz5788z.aspx[^]
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

You can also create a sqlserver user for your web site and specify the connection string using username and pass instead of using integrated security.
 
Working with SQL Server Logins[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

I jus gave permissions to edit in the database property.it s working fine now.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Zoltán Zörgő 300
1 /\jmot 205
2 Peter Leow 165
3 CHill60 145
4 CPallini 135
0 Sergey Alexandrovich Kryukov 9,383
1 OriginalGriff 6,881
2 Peter Leow 4,607
3 Zoltán Zörgő 4,284
4 CHill60 2,892


Advertise | Privacy | Mobile
Web04 | 2.8.150129.1 | Last Updated 13 Aug 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100