System Service Does Not Have Permission Folgen

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 Kommentare

0
Avatar
Shotaro Ito
Aktionen für Kommentare Permalink

[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
Aktionen für Kommentare Permalink

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.

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.