How did you migrate the data? Did you use DTS (Data Transformation Services)? When I migrate a database from one server to another (SQL Server 2000 in my case), I use DTS. From the Enterprise Manager, right-click on your database and select Export Data. When you go through the wizard, I think you have to select Copy object and data between SQL Server databases. This will not only do all the data and views, but it will also do the logins.
>I had to migrate a MSSQL DB from one server to another, and noe rem,ote (not on server) users cannot connect. I have updated MDAC, set authinitication to MS and SQL. I am rapidly running out of ideas. I miss Oracle :(
>Any help would be appreciated, as I'm new to MSSQL
Chris McCandless
Red Sky Software