System Service Does Not Have Permission
Hi - I'm a total SQLEXPRESS newbie. I set up a test database on a network client to try to start logging BarTender jobs.
I got it to successfully link from one other PC (total of 2 counting the original client). However, I get the below error on the other PCs I try. I am sure this is a smiple setting I'm missing. How do I set the permissions so the clients can connect to the database for logging? Thanks!
[attachment=270:System Database.jpg]
I got it to successfully link from one other PC (total of 2 counting the original client). However, I get the below error on the other PCs I try. I am sure this is a smiple setting I'm missing. How do I set the permissions so the clients can connect to the database for logging? Thanks!
[attachment=270:System Database.jpg]
0
-
Shotaro Ito
★ BarTender Hero ★
[quote name='nRyder' timestamp='1342812720' post='2910']
I got it to successfully link from one other PC (total of 2 counting the original client). However, I get the below error on the other PCs I try. I am sure this is a smiple setting I'm missing. How do I set the permissions so the clients can connect to the database for logging? Thanks!
[/quote]
Hi nRyder,
Make sure you run Enterprise Automation edition(or Valid trial) - Automation edition cannot access to remote SQL Server.
Make sure you have allowed remote access to SQL server at install. (if not, you can change setting following instruction below)
[url="http://support.microsoft.com/kb/914277"]How to configure SQL Server 2005 to allow remote connections[/url]
Install SQL Server Management Studio Express to the client and try test connection to the remote database.
[url="http://seagullscientific.invisionzone.com/index.php?/topic/599-error-when-trying-to-connect-remotely"]This topic[/url] and [url="http://seagullscientific.invisionzone.com/index.php?/topic/917-user-authorization-required-to-log-to-database/"]This topic[/url] might helps.0 -
Legacy Poster
★ BarTender Hero ★
Hey nRyder, I'm not sure if you ever got this figured out; but I had this same issue. Solved this in this thread: http://seagullscientific.invisionzone.com/index.php?/topic/599-error-when-trying-to-connect-remotely
Essentially, the Bartender service on all PC's must be using same User Account as the Bartender Service install that is running the "Master" database.
0
Please sign in to leave a comment.
Comments
2 comments