Changing Database Permissions?
Have a question that I'm hoping someone can answer for me...
When you create a new BarTender System Database using the wizard, there's a screen that says "Allow other machines to connect to this database". Lets say I decided to keep it local when I installed it.
Now, however, I want to be able to connect to it remotely. Is there a way to change this setting once the database is already set up? I don't want to have to install another database if I don't have to.
Thanks!
-Jim
When you create a new BarTender System Database using the wizard, there's a screen that says "Allow other machines to connect to this database". Lets say I decided to keep it local when I installed it.
Now, however, I want to be able to connect to it remotely. Is there a way to change this setting once the database is already set up? I don't want to have to install another database if I don't have to.
Thanks!
-Jim
0
-
Shotaro Ito
★ BarTender Hero ★
Hi Jim,
That is SQL Sever's setting.
See How to configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/kb/914277
Basically, from Surface Area Configuratoion tool,
1. Enable Remote connection (Using Both TCP/IP and Named pipes) then Restart SQL Server
2. Enable and Start SQL Server browser service
Note that Connect / Logging to System database on remote SQL Server is only available on Enterprise Automation (Enterprise Print Server) edition.
Hope that helps!0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
1 commentaire