System Service Does Not Have Permission

Legacy Poster

• 2012年07月20日 19:32

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]

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • 2012年07月23日 04:57
  [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 ★

  • 2013年09月20日 21:07

  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

請登入寫評論。