Tuesday, August 19, 2008

SQL Server Frustrations

We're installing a new SQL Server at work. The hardware our current installation runs on is a dual PIII Compaq/HP with 1GB RAM. Hardly the stuff of dreams, but was adequate until recently. Our new server is an HP with dual Quad-Core 64-bit Inter processors and 8GB RAM. Now that is a screaming system.

The only downside is trying to connect to the current server to migrate the data over. This is something we've done many, many times in the past and haven't had any trouble doing. Until now. For some reason, when we try to connect the servers to either import or export the data, the old system doesn't like the authentication of the user and won't work with the file share it wants. We can connect any other SQL Server to our new box, except this one.

We've managed to narrow it down to authentication, mainly Windows Authentication within SQL Server. We can map a drive and connect via Remote Desktop, but when the SQL Server ex/import gets to the "Select File Share" part, the job dies. I don't remember the exact error message, but the idea was that Windows Authentication failed.

I'm very sure the problem lies with the old SQL Server, but I'm not sure where. I've gone over all the settings but I can't seem to work out where the problem is. If anyone has any ideas, please feel free to send them.

No comments:

Post a Comment