Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

create username and password in sqlserver 2008 Expand / Collapse
Author
Message
Posted Thursday, June 17, 2010 4:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 17, 2010 4:18 AM
Points: 1, Visits: 0
Hello everyOne
I want add username and password to my DataBase and use it in my connection string in Asp.Net WebApp, But I don't know how I can do it.
for example: datasource=(local);initialcatalog=.;uid=username;password=password;
That connection string is just an example and may be incorrect!

I have Sqlserver 2008, Vs2008.
Post #938769
Posted Thursday, June 17, 2010 4:32 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 42,765, Visits: 35,863
Databases don't have logins and passwords, servers do. You need to add a SQL login to the SQL instance. If you're sysadmin or security admin you can do it yourself, otherwise ask your DBA.

Management studio, open object explorer and connect to the server. Expand out security, right-click logins -> new login



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #938770
Posted Thursday, June 17, 2010 4:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, June 7, 2014 7:19 PM
Points: 111, Visits: 479
For connection string try this link

http://www.connectionstrings.com/

for creating users please read BOL

http://msdn.microsoft.com/en-us/library/ms173463.aspx


Nag
------------------------------------------------
How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537
Post #938771
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse