Solved

Microsoft SQL Server Error: 233

Posted on 2009-05-20
11
2,461 Views
Last Modified: 2012-05-07
Hi all,
I'm in the proces of migrating a MSSQL2000 Standard Edition database in a shared hosting to environment, over to a dedicated server, MSSQL2008 Web Edition database.

I've done the following:

1. Fully exported the database from MSSQL2000 - my hosting company provided me with this.
2. Imported it into MSSQL2008
3. The database seems to import fine, with all table and the users and so on/

4. Checked for" orphaned" users on MSSQL2008 - none seem to be returned with the following script - whilst connect to the required database as sa.
EXEC sp_change_users_login 'Report';

5. Manually create the user login onto the MSSQL2008 database - and ran:
EXEC sp_change_users_login 'Report';
Still no errors.

However, then I try to connect to the database, I get the following error?!?
Any ideas as to the problem - I'm getting desperate!

Regards

Jamie


MSSQLError.jpg
0
Comment
Question by:Jamie
  • 6
  • 5
11 Comments
 

Author Comment

by:Jamie
Comment Utility
Hi All,
I've been using the following to help me through the process, but still getting the attached error:
http://www.dell.com/downloads/global/solutions/public/white_papers/SQL_2000_SQL_2008_Migration_Guide.pdf
thanks
JamWales
0
 
LVL 13

Expert Comment

by:St3veMax
Comment Utility
On the server; In the SQL Network Configuration; Turn off Named Pipes and Turn On TCP/IP; then restart SQL Service and give it another go.

HTH
0
 

Author Comment

by:Jamie
Comment Utility
Hi St3veMax,
Sorry, I forgot to say - I'm trying to logon, whilst on the actual MSSQL server itself. That said, to be certain I have checked, and named pipes are already disabled, and tcpip enabled.
Thanks
JamWales
MSSQL-Network.jpg
0
 
LVL 13

Expert Comment

by:St3veMax
Comment Utility
OK, WHat you see is identical to our clustered environment.

What happens it you try and connect to SQL from the locally installed management studio ?

Cheers
0
 

Author Comment

by:Jamie
Comment Utility
Hi St3veMax,

The errors I described above are from the locally installed management studio - until this works I have not looked at trying to connect from a remote location. I'm using remote desktop to access the server directly.
Regards
JamWales
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 13

Expert Comment

by:St3veMax
Comment Utility
OK, With you. Disable Shared Memory, Restart SQL Server and try again.
0
 

Author Comment

by:Jamie
Comment Utility
Hi St3veMax,
Tried that and the orginal error has gone - only to be replaced with another one?!

I set the default database to the one that was restored from MSSQL2000  in the login connection properties on Management Studio - plus this has also been set in the login properties on the user (security settings) in the database itself.

 I very much appreciatre the time and help you are giving me - I'm out of my depth with this one!

Regards
JamWales
MSSQL-Error4064.jpg
0
 
LVL 13

Accepted Solution

by:
St3veMax earned 500 total points
Comment Utility
No Worries Jam.

Set your default database to 'Master' and try again.

You will then need to link your login back to the record in teh old db as it will have been orphaned.

EXEC sp_update_users_login 'report'

then

EXEC sp_change_users_login 'update_one', 'yourusername', 'yourusername'

HTH

0
 
LVL 13

Expert Comment

by:St3veMax
Comment Utility
also; You should then be able to change your default database back once you've tested the above.
0
 

Author Closing Comment

by:Jamie
Comment Utility
YAHOOOOOOOOO - It's Works!!!!!!!!!!!!!!!!!!!!!!! Many thanks for your help, saves me drinking 20 cans of Red Bull a day!
JamWales
0
 
LVL 13

Expert Comment

by:St3veMax
Comment Utility
Glad to help...BTW Relentless is better ;o)
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now