daviper
asked on
domain user sql windows authentication
I am working in VBA and have managed to get the code working to my remote SQL server express running on SBS2003. However it works for myself but not for anyone else. I assume this is because I am in the administrators group.
I do not know where or how to add permissions so that all my domain users have access to this particular database or instance or whatever it is they need access to inorder to read and write data. I am learning as I go so I appologize if this is vague or I am WAY off track in my approach.
I do not know where or how to add permissions so that all my domain users have access to this particular database or instance or whatever it is they need access to inorder to read and write data. I am learning as I go so I appologize if this is vague or I am WAY off track in my approach.
' Specify the OLE DB provider.
adoSQL.Provider = "sqloledb"
' Specify connection string on Open method.
strConnection = "Server=claybar-dc1\projectmanagment;Database=projectmanagment;Trusted_Connection=yes"
adoSQL.Open strConnection
ASKER
TCP and Named pipes are enabled inside of the Comp. Manamanget Console.
I am running SQL Man. Studio with SQL 2005 Express
I am running pure Windows Authentication.
I can load the vba program, and it pulls the data from the remote sql database on my SBS2003 server perfectly and quickly. Other users get a "Can't open database "XYZ" requested by logon" "Logon failed"
I am running SQL Man. Studio with SQL 2005 Express
I am running pure Windows Authentication.
I can load the vba program, and it pulls the data from the remote sql database on my SBS2003 server perfectly and quickly. Other users get a "Can't open database "XYZ" requested by logon" "Logon failed"
Have their windows credentials been added to SQL Server logins?
or better yet, does the impersonated account from your application have a login to the server?
or better yet, does the impersonated account from your application have a login to the server?
ASKER
Sorry I have no idea what that is so I am going to go with no. I have seen some of the permissons items inside of SQL. But I dont see how to add users there. This is probably where I went wrong and need help.
Oh wait a minute, you're using SQL Server Express. Theres special syntax for that.
"Data Source=.\SQLExpress;Persis t Security Info=True;Integrated Security=SSPI;Initial Catalog=YourUserId_Databas eName"
"Data Source=.\SQLExpress;Persis
Actually you can just change yours to this:
"Server=claybar-dc1\SQLExp ress;Datab ase=projec tmanagment ;Trusted_C onnection= yes"
"Server=claybar-dc1\SQLExp
ASKER
Isnt that exactly what I have in my code snippet? Because the program works for me just not for anyone besides me. I can try putting someone else in the domain group on server and see if that helps
ASKER
Woops I ment to say put someone else in the ADMIN group
ASKER
So I added a test user to the built in adminstrator group and that user was able to access the database as well..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My problem though is I do not know how to add a new group to sql or to the folder holding sql. I do not know where I need to add the group, how to do it etc.
ASKER
Do i have to specify permissions on the actual SQL folder on the Cdrive?
ASKER
It is working now, I added domain users to the security group and give sysadmin role to the group. I also added domain users to the physical folder housing the database. I will play and see what I have to do from this point foward but it does work, and thank you for the help and guiding hand.
2. What kind of authenication are you using SQL or Mixed?
3. Are TCP and NAMED PIPES enabled for remote access?
Let me know if you need clarification