SQL Server Domains/Workgroups

[BobbaBuoy]

I have a network that has 10 machines-6 of them have sql server registrations. I am able to access all 6 from any machine while they are on the domain. However I also need to take 5 of them off of the domain to a remote site and set up a workgroup. I am able to log in to each sql server from the workgroup login but I am not able to run software on one machine that connects to a sql server registration on another machine in the workgroup. I get a "sql server does not exist or access denied" message. Further, when I open enterprise manager, the other sql servers don't show up and I am unable to add them using the wizard.

Any help would be much appreciated.

 

[SQLSister]

What we did with our dbs on a different dowmain was set up the servers for mixed mode authentication. We set up users with the same loginname and password as the original domain on the other domain, but a SQL Server Standard logins rather than Windows logins. (if you change passwords oftwen you will need to create some type of batch file to proulgate these password changes to the standard logins. Then we gave those users the rights in the new server that they needed. To send data between the two servers we had to set up linked servers.

Also, there were some firewall issues between the domains, but our network guy handled that so I don;t know extaly how that was resolved.

This should give you some ideas of what kinds of things you need to consider.

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[BobbaBuoy]

Ok I am now connecting from machine to machine but it is REALLY SLOW-to the point where the system times out prior to connecting. I am connecting to the machines via a visual basic application and here is my connection string:

conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=VIRA;UID=unknown;Pwd=unknown;Data Source=" & sSource

What would cause that to operate so slowly?

Thanks~