cannot connect to sql 2005 with management studio

Hot Topic

isnull() Problem
Passing connection managers to subpackages.
Error converting data type DBTYPE_DBTIMESTAMP to datetime
Conditional Split to send top 10, top20, and top 30 in three different flows ?
How can I make a Matrix Transposition in SQL ?
Average on a calculated column in matrix
Many-To-Many Self-Join
Getting error in SQL Server Destination
Auto-partitioning
Database Design Question

SQL Server

Recordset Destination
Receive error "Unable to get the window handle for the 'ActionsAwarePivotTable' control." when trying to Browse Cube
Extended Stored Procedures and VB
Errors on Datasource.aspx page
SQL help request
Add the PageHeader, with Title of the report as trhe same time with the image through code
Will run in SSIS Designer but not from DTExec
Convert Binary to Ascii
metadata driven SSIS package--table variable
ETL using SSIS

cannot connect to sql 2005 with management studio

Hi ,

I install sql 2005 CTP but cannot connect to the server with management studio

installation was successful and was named instance and under local system account

in event viewer mssql service is running ok, I see even it connects to master db

I can start and stop server with my old sql agent 2000

and I see only 1 error saying in event log:

The SQL Network Interface library was unable to register SPN. Error: 0x54b.

I  have for OS 2003 server running on my laptop :-)

any help




Answer this question

cannot connect to sql 2005 with management studio

  • BATTY

    thanks just ZoneAlarm firewall was too good - it works fine now Big Smile

  • likhitn

    please read following forum thread.
    http://forums.microsoft.com/msdn/ShowPost.aspx PostID=20067

    hope that solves your problem.

    thanks
    sql blog
  • cannot connect to sql 2005 with management studio
Answer this question