SQL Server Authentication - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Server Authentication

Author

Topic

derok
Starting Member

14 Posts

Posted - 2008-04-06 : 18:59:16

Hi,
i am in the "SQL Query Analizer", and i am trying to connect using SQL Server Authentication, but i dont know my login name and password.

where do i get them?

thanks,..

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-06 : 20:26:48

Ask your DBA to reset password.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-06 : 21:19:56

Get them from people who manage that sql server.

derok
Starting Member

14 Posts

Posted - 2008-04-12 : 22:52:20

no,
i meant for my own pc,
i am in my pc in my house, and i have sql server, but i dont know my username and password.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-12 : 23:04:42

How do you expect us to know it?

Did you try connecting via WIndows Authentication?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

derok
Starting Member

14 Posts

Posted - 2008-04-12 : 23:21:00

quote:
Originally posted by tkizer

How do you expect us to know it?

Did you try connecting via WIndows Authentication?

yea, Windows Authentication works fine,
but i want to connect using SQL Server Authentication, because i am working in a visual .net project,
and in this line:


 cnn1 = New SqlClient.SqlConnection("Data source=(local); User Id = ...; password = ...; Initial Catalog=NorthWind")

i must place the username and password

what can i do?

..

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-13 : 00:29:19

Then you have to create a in sql server or use sa account if you know its password.

derok
Starting Member

14 Posts

Posted - 2008-04-13 : 11:19:30

quote:
Originally posted by rmiao

Then you have to create a in sql server or use sa account if you know its password.

how do i create a in sql server?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-13 : 15:50:04

I missed 'login'. Should create sql login before you can logon with sql authentication.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources