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
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



Group: General Forum Members
Last Login: Today @ 4:45 AM
Points: 42,997, Visits: 39,970
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, 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


Group: General Forum Members
Last Login: Tuesday, May 26, 2015 1:05 AM
Points: 111, Visits: 524
For connection string try this link

for creating users please read BOL

How to get the best help on a forum
Post #938771
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse