Solved

Microsoft SQL Server Error: 233

Posted on 2009-05-20
11
2,477 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 

Author Comment

by:Jamie
ID: 24429403
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
ID: 24429423
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
ID: 24429541
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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 13

Expert Comment

by:St3veMax
ID: 24429559
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
ID: 24429593
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
 
LVL 13

Expert Comment

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

Author Comment

by:Jamie
ID: 24429745
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
ID: 24429766
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
ID: 24429771
also; You should then be able to change your default database back once you've tested the above.
0
 

Author Closing Comment

by:Jamie
ID: 31583396
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
ID: 24429914
Glad to help...BTW Relentless is better ;o)
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Job Hung 17 37
SQL Query Task 11 43
How can I retrieve the column names from a T-SQL table? 2 16
Sql server Error message 3 16
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

749 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