cannot execute sp/access sp properties using gui

I am not able to right click to execute a stored procedure or right click to access the stored procedure properties using Management Studio. Any ideas on what is causing this or if it is supposed to be this way?

Any help is much appreciated.

hi,

does the user you are in the database have enought permissions to do that?

regards

|||

Thanks for the response Andrea,

I login as sa.

Suppose I could mention this is on my local machine. Executing @.@.version returns:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

I am the first one to be running on 2005 locally. Everyone else is still at 2000 so I have not been able to compare against other machines running express.

cannot execute sp/access sp properties using gui

I am not able to right click to execute a stored procedure or right click to access the stored procedure properties using Management Studio. Any ideas on what is causing this or if it is supposed to be this way?

Any help is much appreciated.

hi,

does the user you are in the database have enought permissions to do that?

regards

|||

Thanks for the response Andrea,

I login as sa.

Suppose I could mention this is on my local machine. Executing @.@.version returns:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

I am the first one to be running on 2005 locally. Everyone else is still at 2000 so I have not been able to compare against other machines running express.

Cannot display database properties windows in Sql server management studio.

I use sql server 2005 developer edition with service pack 1.

When i right click on a database and i select properties an error occured with the folowing stack trace

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

Cannot show requested dialog.

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

Cannot show requested dialog. (SqlMgmt)

Program Location:

at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

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

Object reference not set to an instance of an object. (System.Data)

Program Location:

at System.Data.SqlClient.TdsParserStateObject.ReadStringWithEncoding(Int32 length, Encoding encoding, Boolean isPlp)
at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadColumnData()
at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)
at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetObjectByKey(ObjectKeyBase key)
at Microsoft.SqlServer.Management.Smo.DatabaseCollection.get_Item(String name)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.DatabaseData..ctor(CDataContainer context, String databaseName)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.LoadDefinition(String newName)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype..ctor(CDataContainer context)
at Microsoft.SqlServer.Management.SqlManagerUI.DBPropSheet..ctor(CDataContainer context)

Accroding to the reflected sources:

public DatabaseData(CDataContainer context, string databaseName)
{
this.mirrorSafetyLevel = MirroringSafetyLevel.Off;
this.witnessServer = string.Empty;
Database database1 = context.Server.Databases[databaseName];

There might be a problem in getting the information from the database collection. So do the following steps:

-Run the profiler to the when the execution of the command stops. (Guess it has to do something with the database name)
-Select the database name from the sysdatabases and post it here

SELECT Name, DATALENGTH(Name),LEN(Name) from sys.databases

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

When i try to create a new view, in any of the databases i saw an error

Object reference not set to an instance of an object. (SQLEditors)

Program Location:

at System.Data.SqlClient.TdsParserStateObject.ReadStringWithEncoding(Int32 length, Encoding encoding, Boolean isPlp)
at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadColumnData()
at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname)
at Microsoft.SqlServer.Management.Smo.Database.get_DefaultSchema()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.GetDefaultSchema(Server server, String databaseName)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.GenerateNewObjectUrn()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.SetObjectAndParentUrns(Urn originalUrn)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProjectNode..ctor(Urn urn, DocumentOptions options, IManagedConnection connection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProjectNode.Allocate(Urn origUrn, DocumentType editorType, DocumentOptions options, IManagedConnection connection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

I think that there is a problem with the server installation. I will try to reinstalle it.

|||If you want to solve the problem, follow the mentioned steps to reproduce the executed script on the server. That might also help others to solve their problems and help to improve the product itself.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi,

Please make sure the database exists and is not deleted by clicking refresh on the server node and see if you can still see the database whose properties you were not able to access. I believe the database was dropped by some other means and your SSMS window was not refreshed after that.

Hope this helps.

Thanks,

Sravanthi.

|||Stack trace dump means there might be a probelm with the Windows, a virus or mismatch of hotfix/service pack on operating system. Make sure to check what has been changed since this was working correctly in previous state, if not you might try testing the same on other machine.|||All databases are in place. i can open tables and see their data.|||

thats what i believe too.

The problem appears after an update from microsoft windows update which find that my windows sql server installation need the service pack 1 update. I selected and install it.

after that i download and install service pack 2 for sql server 2005 but of course this doesn't correct anything.

I have in the same computer a sqlserver express edition installed and from microsoft sql server managment studio i can work properly with this instance without a problem (in case i thought that was a problem from microsoft sql server managment studio).

About response from Jens K. Suessmeyer .

Whene i execute the line

SELECT 'AdventureWorks', DATALENGTH('AdventureWorks'),LEN('AdventureWorks') from sys.databases

i get

'An error occurred while executing batch. Error message is: Object reference not set to an instance of an object.'

with any database there are in this installation.

|||

Hi,

From where are you running the queries? Please run the query SELECT Name, DATALENGTH(Name),LEN(Name) from sys.databases (run it as is as Jens K. Suessmeyer has given, dont replace Name in the query, if you want it specific to AdventureWorks just add a where clause). Run this query from new query window in SSMS and let us know the output. From the error that you are getting "Object reference..." looks like you are trying to run the query programmatically. Just run it from a SSMS query window and let us know the output. Make sure the database that is causing all these issues comes up in the query result.

Sravanthi

|||If you believe its SSMS tools problem, try to reinstall them again.|||

All databases causing that issues

The result after executing the above query is

NAME (no column name) (no column name)

master 12 6
tempdb 12 6
model 10 5
msdb 8 4
ReportServer$MAIMOY2005 46 23
ReportServer$MAIMOY2005TempDB 58 29
BASE DE DATOS ORIGINAL 44 22
ALKI 8 4
aspnetdb_ALKI 26 13
AdventureWorks 28 14
AdventureWorksDW 32 16

(11 row(s) affected)

|||After a full uninstall and reinstall everything seems to work perfect. Aftes installation i install also service pack 2 downloaded and installed locally and everything works properly.|||

somehow, i missed this thread and I am sure if I could furnish this information bit earlier it would have been helpful. nevertheless, i think i should share my experience in this regards. the story is as follows :)

One of our development server had the same problem and I have documented this error. But at that time I was on the tows and somehow I was to get rid of this problem and I did the same trick - reinstalling the SQL Server. But I was not satisfied by this solution. when I did the postmortem of the process then I realized that our TL used to synchronies the Development database from Visio. There were many connection used to connect to different database (from visio) and one of them was to connect to master database. He used the master connection , and Visio automatically detects the objects in the connected database which are not there in the Model and it ask whether u want to delete those object or not. He selected Yes and Visio deleted all the objects from master database which are not there in the model. I verified the objects between two instances Master databases. There were five system tables missing , the missing tables were spt_fallback_db,spt_fallback_dev,spt_fallback_usg,spt_monitor,spt_value. Then I created the script of these tables from other instance and run on the problem server, but those tables were not having owner , though it shows owner as DBO. Actually these tables comes under System Tables tree but when I created these by the script those created as user table. I was pretty sure that these problem were because of these tables got deleted. But I was not having time to do R&D on this and I reinstalled the instance.

(a) How come Visio able to delete system tables (the irony is that , in SSMO these tables are shown as System Tables , but if u use sp_help it is shown as Usertable).

(b) IF somehow these tables got deleted, how can we restore these table and revert back to normal stage without reinstalling anything.

Also question to Antonisk, is something like this was happened in your side…

I think we need to dig out the root of this problem. If these tables are so critical , then these should not be deletable from anywhere. If it is a bug the we need to report this to MS..

Thanks for the time

Madhu

|||I don't use Visio at all. Also i can't check if this was the problem (system tables missing) because I reinstall the Sql Server.

Cannot display database properties windows in Sql server management studio.

I use sql server 2005 developer edition with service pack 1.

When i right click on a database and i select properties an error occured with the folowing stack trace

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

Cannot show requested dialog.

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

Cannot show requested dialog. (SqlMgmt)

Program Location:

at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

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

Object reference not set to an instance of an object. (System.Data)

Program Location:

at System.Data.SqlClient.TdsParserStateObject.ReadStringWithEncoding(Int32 length, Encoding encoding, Boolean isPlp)
at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadColumnData()
at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)
at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetObjectByKey(ObjectKeyBase key)
at Microsoft.SqlServer.Management.Smo.DatabaseCollection.get_Item(String name)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.DatabaseData..ctor(CDataContainer context, String databaseName)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.LoadDefinition(String newName)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype..ctor(CDataContainer context)
at Microsoft.SqlServer.Management.SqlManagerUI.DBPropSheet..ctor(CDataContainer context)

Accroding to the reflected sources:

public DatabaseData(CDataContainer context, string databaseName)
{
this.mirrorSafetyLevel = MirroringSafetyLevel.Off;
this.witnessServer = string.Empty;
Database database1 = context.Server.Databases[databaseName];

There might be a problem in getting the information from the database collection. So do the following steps:

-Run the profiler to the when the execution of the command stops. (Guess it has to do something with the database name)
-Select the database name from the sysdatabases and post it here

SELECT Name, DATALENGTH(Name),LEN(Name) from sys.databases

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

When i try to create a new view, in any of the databases i saw an error

Object reference not set to an instance of an object. (SQLEditors)

Program Location:

at System.Data.SqlClient.TdsParserStateObject.ReadStringWithEncoding(Int32 length, Encoding encoding, Boolean isPlp)
at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadColumnData()
at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname)
at Microsoft.SqlServer.Management.Smo.Database.get_DefaultSchema()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.GetDefaultSchema(Server server, String databaseName)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.GenerateNewObjectUrn()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.SetObjectAndParentUrns(Urn originalUrn)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProjectNode..ctor(Urn urn, DocumentOptions options, IManagedConnection connection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProjectNode.Allocate(Urn origUrn, DocumentType editorType, DocumentOptions options, IManagedConnection connection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

I think that there is a problem with the server installation. I will try to reinstalle it.

|||If you want to solve the problem, follow the mentioned steps to reproduce the executed script on the server. That might also help others to solve their problems and help to improve the product itself.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi,

Please make sure the database exists and is not deleted by clicking refresh on the server node and see if you can still see the database whose properties you were not able to access. I believe the database was dropped by some other means and your SSMS window was not refreshed after that.

Hope this helps.

Thanks,

Sravanthi.

|||Stack trace dump means there might be a probelm with the Windows, a virus or mismatch of hotfix/service pack on operating system. Make sure to check what has been changed since this was working correctly in previous state, if not you might try testing the same on other machine.|||All databases are in place. i can open tables and see their data.|||

thats what i believe too.

The problem appears after an update from microsoft windows update which find that my windows sql server installation need the service pack 1 update. I selected and install it.

after that i download and install service pack 2 for sql server 2005 but of course this doesn't correct anything.

I have in the same computer a sqlserver express edition installed and from microsoft sql server managment studio i can work properly with this instance without a problem (in case i thought that was a problem from microsoft sql server managment studio).

About response from Jens K. Suessmeyer .

Whene i execute the line

SELECT 'AdventureWorks', DATALENGTH('AdventureWorks'),LEN('AdventureWorks') from sys.databases

i get

'An error occurred while executing batch. Error message is: Object reference not set to an instance of an object.'

with any database there are in this installation.

|||

Hi,

From where are you running the queries? Please run the query SELECT Name, DATALENGTH(Name),LEN(Name) from sys.databases (run it as is as Jens K. Suessmeyer has given, dont replace Name in the query, if you want it specific to AdventureWorks just add a where clause). Run this query from new query window in SSMS and let us know the output. From the error that you are getting "Object reference..." looks like you are trying to run the query programmatically. Just run it from a SSMS query window and let us know the output. Make sure the database that is causing all these issues comes up in the query result.

Sravanthi

|||If you believe its SSMS tools problem, try to reinstall them again.|||

All databases causing that issues

The result after executing the above query is

NAME (no column name) (no column name)

master 12 6
tempdb 12 6
model 10 5
msdb 8 4
ReportServer$MAIMOY2005 46 23
ReportServer$MAIMOY2005TempDB 58 29
BASE DE DATOS ORIGINAL 44 22
ALKI 8 4
aspnetdb_ALKI 26 13
AdventureWorks 28 14
AdventureWorksDW 32 16

(11 row(s) affected)

|||After a full uninstall and reinstall everything seems to work perfect. Aftes installation i install also service pack 2 downloaded and installed locally and everything works properly.|||

somehow, i missed this thread and I am sure if I could furnish this information bit earlier it would have been helpful. nevertheless, i think i should share my experience in this regards. the story is as follows :)

One of our development server had the same problem and I have documented this error. But at that time I was on the tows and somehow I was to get rid of this problem and I did the same trick - reinstalling the SQL Server. But I was not satisfied by this solution. when I did the postmortem of the process then I realized that our TL used to synchronies the Development database from Visio. There were many connection used to connect to different database (from visio) and one of them was to connect to master database. He used the master connection , and Visio automatically detects the objects in the connected database which are not there in the Model and it ask whether u want to delete those object or not. He selected Yes and Visio deleted all the objects from master database which are not there in the model. I verified the objects between two instances Master databases. There were five system tables missing , the missing tables were spt_fallback_db,spt_fallback_dev,spt_fallback_usg,spt_monitor,spt_value. Then I created the script of these tables from other instance and run on the problem server, but those tables were not having owner , though it shows owner as DBO. Actually these tables comes under System Tables tree but when I created these by the script those created as user table. I was pretty sure that these problem were because of these tables got deleted. But I was not having time to do R&D on this and I reinstalled the instance.

(a) How come Visio able to delete system tables (the irony is that , in SSMO these tables are shown as System Tables , but if u use sp_help it is shown as Usertable).

(b) IF somehow these tables got deleted, how can we restore these table and revert back to normal stage without reinstalling anything.

Also question to Antonisk, is something like this was happened in your side…

I think we need to dig out the root of this problem. If these tables are so critical , then these should not be deletable from anywhere. If it is a bug the we need to report this to MS..

Thanks for the time

Madhu

|||I don't use Visio at all. Also i can't check if this was the problem (system tables missing) because I reinstall the Sql Server.sql

cannot debug class liberary sproc

im trying to debug a sproc that was written as a class liberary, in c#. i go to the debug menu in visual studio, and click "attach to process". i attach to the sqlsevr process. but now, any breakpoints i create give the message :

"he breakpoint will not currently be hit. no symbols have been loaded for this document"

and no matter how i execute the sproc in sql server, my breakpoints are never hit. what is wrong here?

Have you uploaded the debug symbols file to SQL Server?

ALTER ASSEMBLY your_asm_name
add file from 'some location'

You better check the syntax for ALTER ASSEMBLY as I wrote it from memory and I don't have BOL handy at the moment.

Niels|||Hmm, I was almost certain I had replied to this a couple of minutes ago (I apologize if this post appears twice).

Have you uploaded the debug symbols file from your assembly to the database?

The syntax is as follows:

ALTER ASSEMBLY your_asm_name
ADD FILE FROM 'path_to_debug_symbols'

You better check the syntax above, as I wrote it from memory and I don't have BOL handy.

Nielssql

Cannot create subscription in with Report Manager

While on the Report Delivery Options page if I click "Select Schedule" or
"OK" nothing happens; no error message, no postback, nothing in the logs,
nothing in a SQL Trace. I cannot create a File Share nor an e-mail
subcription.
I am able to programmaticaly (using ReportServer WebService and
ASP.NET/VB.NET) create a subscription but not with the Report Manager. Any
ideas?have you checked who you are logged into report manager as. What user. do
they have permissions to create a schedule?
"mbianco21" wrote:
> While on the Report Delivery Options page if I click "Select Schedule" or
> "OK" nothing happens; no error message, no postback, nothing in the logs,
> nothing in a SQL Trace. I cannot create a File Share nor an e-mail
> subcription.
> I am able to programmaticaly (using ReportServer WebService and
> ASP.NET/VB.NET) create a subscription but not with the Report Manager. Any
> ideas?sql

Cannot create Recurring backup

I am not able to create a recurring backup job on sql2005. There is no
schedule option when you right click on database then tasks-->backup, also
when I try to do it thru maintenance plan I am not able to see my databases.
Can someone tell me how to resolve this problem?
Thanks in advance for any help-RobRob wrote:
> I am not able to create a recurring backup job on sql2005. There is no
> schedule option when you right click on database then tasks-->backup, al
so
> when I try to do it thru maintenance plan I am not able to see my database
s.
> Can someone tell me how to resolve this problem?
> Thanks in advance for any help-Rob
Don't use the pointy-clicky interface, instead script your backups.
Create a SQL Agent job that uses the BACKUP DATABASE/BACKUP LOG commands.
http://realsqlguy.com/twiki/bin/vie...realsqlguy.com|||Rob wrote on Wed, 12 Jul 2006 13:39:02 -0700:

> I am not able to create a recurring backup job on sql2005. There is no
> schedule option when you right click on database then tasks-->backup,
> also when I try to do it thru maintenance plan I am not able to see my
> databases. Can someone tell me how to resolve this problem?
> Thanks in advance for any help-Rob
Did you restore these databases from a SQL2000 or older server? If so, they
have compatibility set to 80 or lower, and the Maintenance Plan will ignore
them. Change each database to compatibility 90 and they'll then be
selectable in the GUI maintenance plan.
Dan

Cannot create Recurring backup

I am not able to create a recurring backup job on sql2005. There is no
schedule option when you right click on database then tasks-->backup, also
when I try to do it thru maintenance plan I am not able to see my databases.
Can someone tell me how to resolve this problem?
Thanks in advance for any help-RobRob wrote:
> I am not able to create a recurring backup job on sql2005. There is no
> schedule option when you right click on database then tasks-->backup, also
> when I try to do it thru maintenance plan I am not able to see my databases.
> Can someone tell me how to resolve this problem?
> Thanks in advance for any help-Rob
Don't use the pointy-clicky interface, instead script your backups.
Create a SQL Agent job that uses the BACKUP DATABASE/BACKUP LOG commands.
http://realsqlguy.com/twiki/bin/view/RealSQLGuy/AutomaticBackupOfAllDatabases
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Rob wrote on Wed, 12 Jul 2006 13:39:02 -0700:
> I am not able to create a recurring backup job on sql2005. There is no
> schedule option when you right click on database then tasks-->backup,
> also when I try to do it thru maintenance plan I am not able to see my
> databases. Can someone tell me how to resolve this problem?
> Thanks in advance for any help-Rob
Did you restore these databases from a SQL2000 or older server? If so, they
have compatibility set to 80 or lower, and the Maintenance Plan will ignore
them. Change each database to compatibility 90 and they'll then be
selectable in the GUI maintenance plan.
Dan

Cannot create new SQL database.....

I have Visual Studio 2005 Pro. I installed SQL Express 2005 and rebooted.
But, when I right click on "Data Connections" in the Server Explorer and
choose "Create New SQL Server Database..." and attempt to create a new
database on the local PC, I get the following error "An error has occurred
while establishing a connection to the server. When connecting to SQL
Server 2005, this failure may be caused by the fact that under default
settings SQL Server does not allow remote connections. (provider:
NamedPipes Provider, error:40 - Could not open a connection to SQL Server)".
Any idea what this is?You might get some information by looking in the latest error log in the
c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG directory. It looks
like your connection is trying to use named pipes to connect and named pipes
are disabled by default in SQL Express so you might try enabling named pipes
with the SQL Server Configuration Manager.(network configuration/protocols)
You may also have to allow SQL Server to open connections through the XP
firewall but that's usually not necessary.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"wally" <wally@.mart.com> wrote in message
news:7PDpg.16987$7K2.406@.bignews2.bellsouth.net...
>I have Visual Studio 2005 Pro. I installed SQL Express 2005 and rebooted.
>But, when I right click on "Data Connections" in the Server Explorer and
>choose "Create New SQL Server Database..." and attempt to create a new
>database on the local PC, I get the following error "An error has occurred
>while establishing a connection to the server. When connecting to SQL
>Server 2005, this failure may be caused by the fact that under default
>settings SQL Server does not allow remote connections. (provider:
>NamedPipes Provider, error:40 - Could not open a connection to SQL
>Server)".
> Any idea what this is?
>|||Thanks for the pointers.....but no luck.
To make sure that my installation of SQL Express was good, I uninstalled SE
and deleted the directory it leaves behind.
I restarted the dev box, downloaded SE Basic from
http://msdn.microsoft.com/vstudio/express/sql/download/ and reinstalled it
with the client tools selected.
I tried again....same error.
I enabled both TCP/IP and Named Pipes, restarted the dev box and got the
same error.
I disabled the Windows firewall and tried again....same error.
At this point, I am at a loss as to what the problem could be.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uHhVVQXnGHA.4452@.TK2MSFTNGP05.phx.gbl...
> You might get some information by looking in the latest error log in the
> c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG directory. It
> looks like your connection is trying to use named pipes to connect and
> named pipes are disabled by default in SQL Express so you might try
> enabling named pipes with the SQL Server Configuration Manager.(network
> configuration/protocols) You may also have to allow SQL Server to open
> connections through the XP firewall but that's usually not necessary.

> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "wally" <wally@.mart.com> wrote in message
> news:7PDpg.16987$7K2.406@.bignews2.bellsouth.net...
>|||@.!#@.#!@.$!@.......The answer is that you CANNOT connect to SQL Express using
the machine name (nevermind that is what is shown in the drop down for the
connection and SQL Express is running as a service that could be queried).
You must manually add "\SQLExpress" (i.e. "machineName\SQLExpress") to be
able to connect to it.
Now just why didn't those brilliant Microsoft minds code that OR AT LEAST
LET US KNOW ABOUT IT?
"wally" <wally@.mart.com> wrote in message
news:eFHpg.81373$qd2.64435@.bignews6.bellsouth.net...
> Thanks for the pointers.....but no luck.
> To make sure that my installation of SQL Express was good, I uninstalled
> SE and deleted the directory it leaves behind.
> I restarted the dev box, downloaded SE Basic from
> http://msdn.microsoft.com/vstudio/express/sql/download/ and reinstalled it
> with the client tools selected.
> I tried again....same error.
> I enabled both TCP/IP and Named Pipes, restarted the dev box and got the
> same error.
> I disabled the Windows firewall and tried again....same error.
> At this point, I am at a loss as to what the problem could be.
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:uHhVVQXnGHA.4452@.TK2MSFTNGP05.phx.gbl...
>
>
>
>|||Wally,
Have you installed in past some Beta SQL server products, than you have to
look in the mydocuments folders, it is possible that there are than some
orphaned files. Set those temportaly an other place and try to install
SQLExpress again.
Cor
"wally" <wally@.mart.com> schreef in bericht
news:eFHpg.81373$qd2.64435@.bignews6.bellsouth.net...
> Thanks for the pointers.....but no luck.
> To make sure that my installation of SQL Express was good, I uninstalled
> SE and deleted the directory it leaves behind.
> I restarted the dev box, downloaded SE Basic from
> http://msdn.microsoft.com/vstudio/express/sql/download/ and reinstalled it
> with the client tools selected.
> I tried again....same error.
> I enabled both TCP/IP and Named Pipes, restarted the dev box and got the
> same error.
> I disabled the Windows firewall and tried again....same error.
> At this point, I am at a loss as to what the problem could be.
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:uHhVVQXnGHA.4452@.TK2MSFTNGP05.phx.gbl...
>
>
>
>|||Thanks for the help Cor, but the name thing was the issue.
"Cor Ligthert [MVP]" <notmyfirstname@.planet.nl> wrote in message
news:uAUuyfZnGHA.4172@.TK2MSFTNGP03.phx.gbl...
> Wally,
> Have you installed in past some Beta SQL server products, than you have to
> look in the mydocuments folders, it is possible that there are than some
> orphaned files. Set those temportaly an other place and try to install
> SQLExpress again.
> Cor
> "wally" <wally@.mart.com> schreef in bericht
> news:eFHpg.81373$qd2.64435@.bignews6.bellsouth.net...
>|||Wally,
Sorry I did not look well to your follow up. AFAIK does a dot this as well.
Cor
"wally" <wally@.mart.com> schreef in bericht
news:uYIpg.81378$qd2.31318@.bignews6.bellsouth.net...
> Thanks for the help Cor, but the name thing was the issue.
>
> "Cor Ligthert [MVP]" <notmyfirstname@.planet.nl> wrote in message
> news:uAUuyfZnGHA.4172@.TK2MSFTNGP03.phx.gbl...
>|||On Sun, 2 Jul 2006 01:12:26 -0400, "wally" <wally@.mart.com> wrote:

>@.!#@.#!@.$!@.......The answer is that you CANNOT connect to SQL Express using
>the machine name (nevermind that is what is shown in the drop down for the
>connection and SQL Express is running as a service that could be queried).
>You must manually add "\SQLExpress" (i.e. "machineName\SQLExpress") to be
>able to connect to it.
>Now just why didn't those brilliant Microsoft minds code that OR AT LEAST
>LET US KNOW ABOUT IT?
Wally,
The machineName\instanceName thing is well documented in assorted
places. But there is just so much information around that it may not
be easy to find, particularly if you don't know that you need to look
for it.
Andrew Watt MVP

Cannot create new roles for users or groups as well as folders

Good afternoon,
I cannot seem to create or modify both roles and folders in Report Manager.
When I click on OK in the form to create or modify existing items nothing
happens. Am I forgetting something?
I had an issue during the installation or RS that may weigh in... the
installation of RS would fail at the final phase and give me an error (25619
- KB Article 867872). There is a knowledgebase article for this. It details
using a parameter to not create the virtual folders for Reports and
ReportServer and how to create the virtual folders and it's permissions
afterwards. This completed the installation and everything else, aside from
this issue, appears to be operatin normally.
Specs:
Windows Server 2003
SQL Server 2000 w/ SP3
SQL RS w/ SP1Disregard... another thread gave me the answer:
on the server run:
aspnet_regiis -c
from the .Net framwork dir.
"Peter Capazzi" wrote:
> Good afternoon,
> I cannot seem to create or modify both roles and folders in Report Manager.
> When I click on OK in the form to create or modify existing items nothing
> happens. Am I forgetting something?
> I had an issue during the installation or RS that may weigh in... the
> installation of RS would fail at the final phase and give me an error (25619
> - KB Article 867872). There is a knowledgebase article for this. It details
> using a parameter to not create the virtual folders for Reports and
> ReportServer and how to create the virtual folders and it's permissions
> afterwards. This completed the installation and everything else, aside from
> this issue, appears to be operatin normally.
> Specs:
> Windows Server 2003
> SQL Server 2000 w/ SP3
> SQL RS w/ SP1
>

Cannot create diagrams in SQLSERVER 2005

Hi,
Every time I click on the Database Diagram node in object explorer in SQL
Server Management Studio, I get a message:
Database diagram support objects cannot be installed because this database
does not have a valid owner. ...
I have checked the owner and it coincides with my logon name in my domain
(i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
problem with Active Directory? Why am I not being recognized as a valid db
owner?
Thanks in advance,
Juan Dent, M.Sc.
Make sure the compatibility level of the databases is set to
90 - that's often what causes the problem.
You can set it to 90 using:
EXEC sp_dbcmptlevel 'database name', '90'
-Sue
On Mon, 23 Jan 2006 17:04:01 -0800, Juan Dent
<Juan_Dent@.nospam.nospam> wrote:

>Hi,
>Every time I click on the Database Diagram node in object explorer in SQL
>Server Management Studio, I get a message:
> Database diagram support objects cannot be installed because this database
>does not have a valid owner. ...
>I have checked the owner and it coincides with my logon name in my domain
>(i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
>problem with Active Directory? Why am I not being recognized as a valid db
>owner?
|||Juan Dent (Juan_Dent@.nospam.nospam) writes:
> Every time I click on the Database Diagram node in object explorer in SQL
> Server Management Studio, I get a message:
> Database diagram support objects cannot be installed because this
> database does not have a valid owner. ...
> I have checked the owner and it coincides with my logon name in my domain
> (i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
> problem with Active Directory? Why am I not being recognized as a valid db
> owner?
This typically happens when you migrate a database from another server.
The problem can be seen by SELECT * FROM sys.database_principals. Compare
the row for dbo with a database created on the server.
I think changing the ownership to some other login, and back to yourself
fixes the issues.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||This site will help. There are two quick steps.
http://mcfunley.com/cs/blogs/dan/arc...12/23/899.aspx

************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Cannot create data-driven subscription

Hi,

I'm using SQL Server 2005 Developer Edition, which I understand supports Data-driven subscriptions (DDS).

When I try and click on on the DDS button for a report I get the following message:

"Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid."

1. I have set the data source to use stored credentials.

2. I'm using one simple string parameter

3. Its not a linked report

Any ideas?

regards,

avner

Make sure your report does not contain expressions depending on user like User!UserID.

See http://msdn2.microsoft.com/en-us/library/ms156012.aspx.

|||

thanks! that resolved the problem.

|||

Hi,

I'm having the same problem. I'm using the browser interface for SSRS and when I click on a report and go to Subscriptions, the buttons for New Subscription and Data-driven Subscription have warning icons, and when I click on either I get the same message as above.

The report already has a data-driven subscription which was working fine. I haven't made any changes to the report. This problem is affecting all reports. What has changed is the data source (now pointing to a different database), which is using "Credentials stored securely on the server" and "Use as Windows credentials..." and "Impersonate the authenticated user..." both checked.

Is there some security setting being cached in the reports? Do I need to update the reports in some way to make them work with the updated data source?

Regards,

Greg

|||

Answering my own question, the problem was the "Impersonate the authenticated user..." option. When I unchecked this for the data source I was able to create subscriptions.

Regards,

Greg

Cannot create data-driven subscription

Hi,

I'm using SQL Server 2005 Developer Edition, which I understand supports Data-driven subscriptions (DDS).

When I try and click on on the DDS button for a report I get the following message:

"Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid."

1. I have set the data source to use stored credentials.

2. I'm using one simple string parameter

3. Its not a linked report

Any ideas?

regards,

avner

Make sure your report does not contain expressions depending on user like User!UserID.

See http://msdn2.microsoft.com/en-us/library/ms156012.aspx.

|||

thanks! that resolved the problem.

cannot connect to the local instance

I have SQL server 2000 installed on my machine,
Under the "SQL Server Group" , if I click on the local insatnce (computerNam
e\NETSDK(window NT)) , I get the following error:
"The SQL server \\computerName\NETSDK is not known to be running, are you s
ure you wish to connect"
if I click yes, I get this second error message:
"A connection could not be established to computername/NETSDK.
Reason: SQL server does not exist or access denied.
ConnectionOpen(Connect())...
Please verify SQL Server is running and check your SQL Server registration p
roperties..."
when I check the registration, nothing look unusual for me.
thanks for helpYou didn't indicate whether you verified that the MSSQLServer service was
running. If so, are you using windows authentication or SQL authentication?
If you are using Windows authentication, try the sa account (assuming you
know/remember the password and that the server is in mixed mode). If you
get in using sa, check to be sure that you haven't removed the
builtin\administrators login without also adding your own. People tend to
forget this and get themselves locked out...
"tony" <myemail@.mail.com> wrote in message
news:2C272FD6-7C9E-441D-9AB7-DE70AC17946F@.microsoft.com...
> I have SQL server 2000 installed on my machine,
> Under the "SQL Server Group" , if I click on the local insatnce
(computerName\NETSDK(window NT)) , I get the following error:
> "The SQL server \\computerName\NETSDK is not known to be running, are you
sure you wish to connect"
> if I click yes, I get this second error message:
> "A connection could not be established to computername/NETSDK.
> Reason: SQL server does not exist or access denied.
> ConnectionOpen(Connect())...
> Please verify SQL Server is running and check your SQL Server registration
properties..."
> when I check the registration, nothing look unusual for me.
> thanks for help
>|||Hi Tony,
Thank you for using the newsgroup and thanks for Don's reply.
Don have pointed out some place you should check first and here I just want
to add some more information for your reference. You could look at this
following article:
INF: Potential Causes of the "SQL Server Does Not Exist or Access Denied"
Error Message
http://support.microsoft.com/?id=328306
Hope this help. If you still have questions, please feel free to post
message here and we are glad to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||the problem occured while backing up a database, the backup failed and I los
t connection to my local instance.
SQL server(as interface) is running fine on my machine and I can connect to
other remote server but not to the local one.
when I try to register the local one (under 'SQL Server Group') , I get an e
rror message saying that 'SQL Server does not exist or .....)
when I check the service, SQLServer service does not have even an entry an
d I couldn't locate it as a service.
I uninstalled SQL server (client tool) and I can still run the client on my
machine as if I didn't uninstall it, but with no connection to the local one
.
I installed it again and still getting the same error message.
The service does not exist, and SQL server is installed, how can that happen
s ?
thank you again.|||how can I add MSSQLServer as a service.
SQL server is running but does not have entry under the Service node.|||Hi Tony,
Thank you for your update.
It is a little strange now. Do you mean that after un-install the SQL
Server, and then in the Services Snap-in in the MMC, you cannot see the
SQL Server Service but your application could still connect to it? When a
SQL Server is running well on you computer, it should have the service
configured on your computer, no matter it is started or stopped.
I would like to narrow down the problem step-by-step
1) Please go to the command prompt ( 'Start'->'Run', then type in 'cmd' and
press Enter), then type 'net start', could you get any service of SQL
Server? It could be
MSSQLSERVER or MSSQL$<instance_name>.
2) If no, type in 'net start MSSQLSERVER, what's the message you get?
Note: For other SQL Server instance, type in 'net start
MSSQL$<The_Instance_Name>'
3) If it said
The MSSQLSERVER service is starting......
The MSSQLSERVER service was started successfully.
OR
The requested service has already been started.
Then you could be sure that the SQL Server is installed on your computer.
Then, please use the Enterprise Manager to register it.
Hope this helps.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Baisong,
Thank you for yall your help.
I reinstalled SQL server (client) again in order to see if it is going to ap
pear in the " Services Snap-in in the MMC",
and it INSTALLED SUCCEFULLY (as the install said) , and I run it, through
"Entreprise Manager", and I could connect to other remote sql servers, but w
hen I tried to register the local instance, I get a message :"SQL server doe
s not exist or..."
then I checked the Services Snap-in in the MMC, but still cannot see it or s
ee any SQL service at all.
Then I followed your instruction excatly:
1) when typing : "net start" , I can see all services except anything for SQ
L or MSSQL or .......
2) when typing : "net start MSSQLSERVER" , that's what I got: "The service
name is invalid"
After done all that, I create a shortcut for "Entreprise Manager" on the des
ktop, then I uninstalled SQL server again.
1) Now I cannot see "Microsoft SQL Sever" entry under start -> Programs ->
Microsoft Sql server anymore,
but the shortcut to it still exist on my desktop, and when I double click it
, it run normally as I didn't uninstall it, and I still
can run queries and connect to other remote servers except the local one, th
en I followed you instruction again, and got
the same message as I got before the uninstall; (nothing for MSSQL.... and
"The service name is inavlid").
Is there anyway to add MSSQLServer as a service in the Services Snap-in in t
he MMC manually ?
Thank you again|||Hi Tony,
Thank you for your update.
From your informtion, it seems you do not installed the SQL Server service
on you machine, just the SQL Server management tools such as the Enterprise
Manager or Query Analyzer.
So, I recommend you to un-installed the tools again. Then check your
Operating System and choose the right edition of SQL Server. Please refer
to the following article:
Operating Systems Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/d...-us/architec/8_
ar_ts_7eur.asp
Then, please re-intall the proper SQL Server 2000 by choosing 'Server and
Client Tools' selection during the intallation. After all the installation,
you will notice the SQL Server Service is in the Server snap-shot in the
MMC.
Hope this helps and if you still have question, please feel free to post
message here and I am glad to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Cannot connect to SQL 2000 remotely

On the server, from the Start menu, point to All Programs, point to
Microsoft SQL Server, and then click Server Network Utility. That utility
should help you understand if SQL Server is using the IPX/SPX or TCP/IP
protocols, which might indicate a problem. On the client there is a similar
program, the Client Network Utility. Obviously the client and server should
be using the same protocols.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clive" <clive.elsworth@.takeoutonetel.net> wrote in message
news:OxUCSSVyHHA.5856@.TK2MSFTNGP02.phx.gbl...
> I'm trying to install a bespoke application for a new client, and am
> embarassed by not being able to connect to their DB Server.
> The server and clients are XP all running on a workgroup called OFFICE
> File access is not problem and the DB Server name appears in a dropdown
> box of SQL servers on the network - e.g. when trying to create an ODBC
> DSN.
> The SQL Server is now configured to accept Windows and SQL authentication
> connection requests - and restarted.
> I have switched off or uninstalled everything that looks like a firewall
> on both server and clients.
> When trying to set up local ODBC DSN to connect as sa, I can connect no
> problem, but from one of the client laptops I just get the error:
> "Access denied or SQL Server does not exist"
> Can anyone tell me where else to look or what else to try?
> Is there a step by step procedure which could take me to the cause of the
> problem?
> The network is a wireless Lan - and IPX/SPX is featuring in the network
> stack. Could that be something to do with it?
> Any help very very much appreaciated!
> Thank you
> Clive (London UK)
>
>
>
>
Glad to help. I recognize customers stress and confusion as a problem that
we (Microsoft) often cause... and have an obligation to resolve.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clive" <clive.elsworth@.takeoutonetel.net> wrote in message
news:O7J9R4pzHHA.3400@.TK2MSFTNGP03.phx.gbl...
> Apologies for flame throwing. Default of DisableNetworkProtocols WAS the
> problem, but in any case
> thank for taking the time and trouble to get back to me Rick.
> Clive Elsworth
>
>
> "Rick Byham, (MSFT)" <rickbyh@.REDMOND.CORP.MICROSOFT.COM> wrote in message
> news:1CAB65A1-509E-4338-8C33-65D98FDA7300@.microsoft.com...
>