Connecting to a SQL Server DB from a local PC

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

SQL Server Administration (2005)

Connecting to a SQL Server DB from a local PC

Author

Topic

KingCarlos
Yak Posting Veteran

74 Posts

Posted - 2009-12-13 : 19:29:42

Connecting to a SQL Server DB from a local PC (non network PC)

I need some assistance regarding SQL connection.

I have a user who logs on to his local PC but the user is required to log on to a piece of software that connects to a SQL database which resides on a server.

How is this done in SQL Server management studio?

I am only familiar with setting up access for users that reside in a domain.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-13 : 19:32:58

I'm not sure what piece of software you are referring to, but if the user isn't in the domain then he/she can connect with SQL authentication instead provided a SQL account has been created for him/her.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

KingCarlos
Yak Posting Veteran

74 Posts

Posted - 2009-12-13 : 19:44:37

So I would create a new login and give it the name

PC-id\user-id

and choose SQL Authenticaion and give the appropiate password?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-13 : 23:42:21

No, that's a Windows account. You need to create a SQL account inside SQL Server, and then the user will connect via SQL authentication instead of Windows authentication.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

KingCarlos
Yak Posting Veteran

74 Posts

Posted - 2009-12-14 : 01:13:29

<I>and then the user will connect via SQL authentication instead of Windows authentication.</I>

Thanks but now I am stuck with the application, I am not sure how the user account will check for the SQL authentication account rather than the windows account authentication.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-14 : 11:08:58

Check with the developer of the application if they can change the connection string to use SQL authentication instead of integrated security. If the connection string is exposed like it is in .NET, then this may be simple. Not sure about the application security side though, so the developer will need to investigate.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

KingCarlos
Yak Posting Veteran

74 Posts

Posted - 2009-12-15 : 20:53:57

Thanks for the tips !!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources