System Service Does Not Have Permission 追蹤

0
Avatar
Legacy Poster

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]

2 意見

0
Avatar
Shotaro Ito
評論操作 永久連結

[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
Avatar
Legacy Poster
評論操作 永久連結

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.

登入寫評論。