Sql Server 2008 R2 express - Instance available to all users?

I am attempting to build a sql server 2008 R2 installer for XP (yes i know but the place i work at still uses XP!)

Here is the problem:

The Sql Server Express 2008 R2 installer works fine for the Admin user of the PC who installed it. The software that uses the Sql Server runs brilliantly.

osql -L returns the correctly named instance.

However when another user logs into that pc, the Sql Server is available - but the created Instance "MyCoolSqlInstance" is not.

osql -L returns an empty list.

How do I make the instance available to all users of the PC? (there will be Admin and non Admin users). 

cheers

Buzz

  • Changed type BuzzBahr2 5 hours 20 minutes ago its a question
January 12th, 2014 11:05pm

Hello,

Do the non admin users have access to the SQL Server instance? To maje the instance available to all users of the PC,

add "NT Authority\Authenticated Users" to the SQL security list.

http://support.microsoft.com/kb/243330/en-gb

Name: Authenticated Users
Description: A group that includes all users whose identities were authenticated when they logged on. Membership is controlled by the operating system.

But the best way of providing access to everyone would be via SQL Authentication. Enable SQL authentication in SQL and use SQL Authentication mode to connect to SQL.

Regards,

Don [MSFT]

Free Windows Admin Tool Kit Click here and download it now
January 13th, 2014 2:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics