Cannot open the local NT group in the SQL Server Group

Hello,
I logged in as administrator, and tried to open the local
NT SQL Server and the message appears:
"A connection could not be established to (local).
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect()).
Please verify SQL Server is running and check your SQL
Server Registration properties (by right-clicking on the
(local node) and try again."
I cannot access the registration properties.
I also checked event viewer and found the following error
message:
"There are multiple accounts with name
MSSQLSvc/mpserver01.martinousproduce.local:1433 of type
10. "
Any ideas on the problem? I restarted the SQL Server but
still unable to connect.
Thanks,
JoeDo you have more than 1 instance of SQL server installed?
Perhaps they are both trying to use the same IP port
number of 1433. Go to your NT services and see how many
instance you have of SQL. Try and start and connect to one
of them and then see if you have a clash of IP port
numbers.
If that isn't the case check that the SQL service is
running (by going to your NT services). Then, check
your "server network utility" from the program menu and if
TCP/IP is there take it out and put in named pipes. If
TCP/IP isn't there, then put it in. Remember you could
affect how people connect to the SQL server (i.e. is it in
production?) so take care when making your changes and
write them down so you don't forget how to undo them.
Hope this helps.
-J
p.s. just one more thought...do you have a name conflict
on the network? If so, it is possible that this SQL
server's IP stack did not initialize and therefore the SQL
services won't start.
>--Original Message--
>Hello,
>I logged in as administrator, and tried to open the local
>NT SQL Server and the message appears:
>"A connection could not be established to (local).
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect()).
>Please verify SQL Server is running and check your SQL
>Server Registration properties (by right-clicking on the
>(local node) and try again."
>I cannot access the registration properties.
>I also checked event viewer and found the following error
>message:
>"There are multiple accounts with name
>MSSQLSvc/mpserver01.martinousproduce.local:1433 of type
>10. "
>Any ideas on the problem? I restarted the SQL Server but
>still unable to connect.
>Thanks,
>Joe
>.
>

Cannot Launch DTA - Failed to open new connection

Installed SQL 2005 STD and installed SP1 for SQL on a Windows 2003 STD server.

I launch DTA and I am logged in with the same windows account which the SQL services use and I get the following message:

===================================

Failed to open a new connection.

===================================

Could not find stored procedure 'msdb..sp_DTA_help_session'. (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=2812&LinkId=20476

Server Name: FHCMS,1433
Error Number: 2812
Severity: 16
State: 62
Line Number: 1

Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.SqlServer.Management.DTA.Client.TuningServer.QuerySessions()
at Microsoft.SqlServer.Management.DTA.Client.TuningServer.InitializeConnection()
at Microsoft.SqlServer.Management.DTA.Client.TuningServer.Connect()
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServerInternal(SqlConnectionInfo connectionInfo, SqlConnection connection)
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServer(SqlConnectionInfo connectionInfo, SqlConnection connection)
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.OnConnect(Object sender, EventArgs e)

Any help would be appreciated.

Thanks,
Pete

are you using RTM or sp1 version? a MSFT guy told me that there are problems he has heard of with DTA in the RTM build...I would tell you that while I love the product, DTA has not been the most stable of components overall from my expereinces w/it.|||

I am using the SP1 version for SQL 2005, I didn't even check to see if DTA worked before that since it is a brand new server.

I saw a post that stated the user does not have sysadmin rights for SQL and that is what the error message means but I created a Domain Admin account for SQL and that is what I am logged on to the server with.

Thanks,
Pete

|||

have you checked all the usual log locations...

sql exception log

event log

unfortunetly i cannot be of any more help at this point.

|||

I have the same trouble.

Cannot Launch DTA - Failed to open new connection

Installed SQL 2005 STD and installed SP1 for SQL on a Windows 2003 STD server.

I launch DTA and I am logged in with the same windows account which the SQL services use and I get the following message:

===================================

Failed to open a new connection.

===================================

Could not find stored procedure 'msdb..sp_DTA_help_session'. (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=2812&LinkId=20476

Server Name: FHCMS,1433
Error Number: 2812
Severity: 16
State: 62
Line Number: 1

Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.SqlServer.Management.DTA.Client.TuningServer.QuerySessions()
at Microsoft.SqlServer.Management.DTA.Client.TuningServer.InitializeConnection()
at Microsoft.SqlServer.Management.DTA.Client.TuningServer.Connect()
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServerInternal(SqlConnectionInfo connectionInfo, SqlConnection connection)
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServer(SqlConnectionInfo connectionInfo, SqlConnection connection)
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.OnConnect(Object sender, EventArgs e)

Any help would be appreciated.

Thanks,
Pete

are you using RTM or sp1 version? a MSFT guy told me that there are problems he has heard of with DTA in the RTM build...I would tell you that while I love the product, DTA has not been the most stable of components overall from my expereinces w/it.|||

I am using the SP1 version for SQL 2005, I didn't even check to see if DTA worked before that since it is a brand new server.

I saw a post that stated the user does not have sysadmin rights for SQL and that is what the error message means but I created a Domain Admin account for SQL and that is what I am logged on to the server with.

Thanks,
Pete

|||

have you checked all the usual log locations...

sql exception log

event log

unfortunetly i cannot be of any more help at this point.

|||

I have the same trouble.