SQL question

Dzha2000 · 04-16-2008, 10:45 PM

Hi Guys.

I have a problem with SQL. I have two servers running 2 separate domains (let's call them old server and new server). I'm trying to migrate users from old to new server. I have a user who need access to SQL on old server (which will not be migrated to new server), but him being on new server. How can I do that without establishing two way trust between domains? was thinking through abour SQL server authentication, but that didn't work either.

if anyone can give me some pointer I would really appreciate it.

Camper · 04-18-2008, 02:46 PM

Sql sever Authentication should have fixed the issue assuming that you are using Microsoft SQL server. From what I know about SQL Server 2005 sql authentication is separate account from Active Directory and all you need is a network connection to the server to log on. What SQL Server are you running?

Dzha2000 · 04-18-2008, 03:38 PM

Quote:

Originally Posted by Camper

Sql sever Authentication should have fixed the issue assuming that you are using Microsoft SQL server. From what I know about SQL Server 2005 sql authentication is separate account from Active Directory and all you need is a network connection to the server to log on. What SQL Server are you running?

from what I can tell it is MS SQL 2000.

I thought that would be the case too, but no, I can't connect to the SQL server with SQL authentication.

Camper · 04-19-2008, 03:37 AM

Sorry I don't have an answer for you but you can go here and look up some information.
http://technet.microsoft.com/en-us/l.../ms950404.aspx

04-16-2008, 10:45 PM	#1 (permalink)
Dzha2000 New Member Join Date: Apr 2008 Posts: 10	SQL question Hi Guys. I have a problem with SQL. I have two servers running 2 separate domains (let's call them old server and new server). I'm trying to migrate users from old to new server. I have a user who need access to SQL on old server (which will not be migrated to new server), but him being on new server. How can I do that without establishing two way trust between domains? was thinking through abour SQL server authentication, but that didn't work either. if anyone can give me some pointer I would really appreciate it.

04-18-2008, 02:46 PM	#2 (permalink)
Camper Diamond Member Join Date: Mar 2005 Location: /dev/null Age: 22 Posts: 1,227	Sql sever Authentication should have fixed the issue assuming that you are using Microsoft SQL server. From what I know about SQL Server 2005 sql authentication is separate account from Active Directory and all you need is a network connection to the server to log on. What SQL Server are you running? __________________ Dell Inspiron 530 Q6600 Quad 3gb RAM Nvidia 8600 GT 500GB HD

04-19-2008, 03:37 AM	#4 (permalink)
Camper Diamond Member Join Date: Mar 2005 Location: /dev/null Age: 22 Posts: 1,227	Sorry I don't have an answer for you but you can go here and look up some information. http://technet.microsoft.com/en-us/l.../ms950404.aspx __________________ Dell Inspiron 530 Q6600 Quad 3gb RAM Nvidia 8600 GT 500GB HD

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If you have a question about the forum administration	ian	Off Topic Chat	0	03-31-2008 09:51 AM
The Amazing Question > Question Game	ramodkk	Off Topic Chat	469	03-13-2008 11:15 AM
Hopefully a simple question about RAM	bugs	Computer Memory and Hard Drives	2	01-11-2007 11:38 PM
Duel Channel Question	Ace1627	Computer Memory and Hard Drives	1	01-05-2005 12:38 AM
embedded sql with C help..segmentation fault?	loserpunkx182	General Software	0	12-08-2004 02:00 AM