Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting to SQL Server 2008 thru Managment Studio error

Status
Not open for further replies.

ton12

Programmer
Mar 9, 2005
58
GB
XP Professional
SQL Server 2008 - Developer Edition

I have SQL Server 2005 installed and running fine.
I installed SQL Server 2008 correctly, no error message.
The instance is named 'SQL2008'. The Server is DELL-BDD3.

When I connect to DELL-BDD3\SQL2008 thru
SQL Server Management Studio, I get this error message:

-----------------------------------------------------------
Cannot cannot to DELL-BDD3\SQL2008.
Additional information:

[C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.
Management.Sdk.Sfc\10.0.0.0_89845dcd8090cc91\Microsoft.SqlServer.Management.Sdk.Sfc.dll]Illegal or
unimplemented ELEM_TYPE in signature.(ObjectExplorer)
-----------------------------------------------------------

Anybody came across this problem?

Tony.


 
Are you trying to connect to the SQL Server 2008 database using SQL Server 2005 Management Studio? If so, it won't work properly. Use SSMS 2008 to connect to a SS2008 database.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
 

I'm using SSMS 2008 which points to :

"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe
 
Ah....it is the dash in the server name. SQL Server doesn't like dashes or spaces in names. Try connecting using square brackets around the server name.

[DELL-BDD3]\SQL2008

See if that resolves your issue.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
 
Hi SQLBill,

Thanks for your suggestion.

I tried with square brackets but still doesn't work.

Tony
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top