PC is on a workgroup not a domain

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)

PC is on a workgroup not a domain

Author

Topic

KingCarlos
Yak Posting Veteran

74 Posts

Posted - 2009-12-15 : 20:56:29

I have a company using my product which uses a SQL database.

They do not have any of their PC on a domain instead they have opted to be on a workgroup.

Any tips on how you get a workgroup user to connect to a separate SQL Server ?

Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-15 : 22:14:40

It's easiest to just use SQL authentication for the user accounts.

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-16 : 16:34:58

IS this done with Management Studio?

Am I correct in thinking you have to create a new login and choose

Object type = Group
Location = ???

Or am I way off target?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-16 : 16:49:02

You do have to create a new login but choose "SQL Server authentication" rather than the default "Windows authentication". You then have to provide a password and some security things (I always uncheck the last two boxes and leave the first one checked). Then you provide those credentials to your customer not on the domain and then he/she logs in with that account and specific SQL authentication during the connection.

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-16 : 16:52:53

Then you provide those credentials to your customer not on the domain and then he/she logs in with that account and specific SQL authentication during the connection

Can you expand a little on that last comment, I got lost at the point of where they log in with that account and specific SQL authentication. Where do they use those credentials?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-16 : 16:59:58

Well in what application do they need to connect? If it's from SSMS, then it prompts you for this information. If it's from a custom application, then this would be done inside the connection string.

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-16 : 17:39:50

Is there an option when logging onto the computer to create a connection to a SQL server using the newly created system admin account and password?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-16 : 18:18:24

I don't think I understand what you are asking.

What system admin account are you referring to?

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-16 : 19:39:43

In the Security section of SQL Management Studio, select the option New Login, and in this screen choose SQL server authentication account rather than windows authentication

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-16 : 19:54:12

That's correct, but what's your question?

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-16 : 20:01:57

my question now is how to use that information when the client logs on to his PC, is there a place to store this info???

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-16 : 20:06:24

You can't use that information when the client logs into the PC. The client must log into a PC with a Windows account (local since it's a workgroup), and then when they want to access the database they specify SQL authentication and the credentials that you created.

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-16 : 20:06:46

The SQL credentials are only for use with SQL Server and not cannot be used for access to anything else, including a PC.

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources