3 Questions

Dear Professionals,
1. Could any one explain in a simple word "what Collation play a role in
SqlServer"
2. I want the restrict all the user to connect only from SA login .. can't
connect through windows authentication.. what I have to do for this ?
3. Which license would be good Per seat or Per processor.
Thanks
NOOR
Noor,
#1. Multi language support.(you asked for a word , okay that was 3:-)
#2: Remove all Windows logins including builtin\administrators and non-sa
sql logins.Juist curious, why do you want to do that?Removing buitin\admin
needs to be done very carefully.
#3. Difficult to say.If one was better than the other why would Microsoft
give you two?Depends on your requirement.See
'How to Buy'
http://www.microsoft.com/sql/howtobuy/default.asp
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Noorali Issani" <naissani@.softhome.net> wrote in message
news:O1Q8UN7QEHA.3140@.tk2msftngp13.phx.gbl...
> Dear Professionals,
> 1. Could any one explain in a simple word "what Collation play a role in
> SqlServer"
> 2. I want the restrict all the user to connect only from SA login .. can't
> connect through windows authentication.. what I have to do for this ?
> 3. Which license would be good Per seat or Per processor.
> Thanks
> NOOR
>
|||Thanks Dinesh..
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%236xQRa8QEHA.3728@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Noor,
> #1. Multi language support.(you asked for a word , okay that was 3:-)
> #2: Remove all Windows logins including builtin\administrators and non-sa
> sql logins.Juist curious, why do you want to do that?Removing buitin\admin
> needs to be done very carefully.
> #3. Difficult to say.If one was better than the other why would Microsoft
> give you two?Depends on your requirement.See
> 'How to Buy'
> http://www.microsoft.com/sql/howtobuy/default.asp
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Noorali Issani" <naissani@.softhome.net> wrote in message
> news:O1Q8UN7QEHA.3140@.tk2msftngp13.phx.gbl...
can't
>

2nd Login failed for user '(null)' ...

This is driving me NUTS!
Sometime on Modday, or the first part of the day Tuesday, I lost my ability
to connect to the servers from my workstation and have been getting the
message: "Login failed for user '(null)' ...".
I think (but am not sure) that this started with my changing the login
account in Windows Services for all the SQL Server entries from my domain
account to the Local account.
I have since completly uninstalled all SQL Servers and tools and then
reinstalled just the SQL Server 2000 client tools. Also, my local profile
was completly removed and I started with a fresh local account.
Now the really bizzare stuff. I (of course) get the error when logged into
my machine and I also get the error when logged into another machine.
However, when our Windows sysadmin logs into my machine, he can connect just
fine.
I am so totally lost, it isn't funny.
OK, my version of the problem has been figured out.
The remote servers I'm dealing with are not part of the domain and we had a
new password policy (on the new QA cluster) that required two additional
characters be added. The Windows sysadmin had me change my domain password
to match - hence a password mismatch and the error.
Once I changed my password back to the old one, I was able to connect again.
Sigh ...
"Jay" <nospam@.nospam.org> wrote in message
news:unwuEGYIIHA.5360@.TK2MSFTNGP03.phx.gbl...
> This is driving me NUTS!
> Sometime on Modday, or the first part of the day Tuesday, I lost my
> ability to connect to the servers from my workstation and have been
> getting the message: "Login failed for user '(null)' ...".
> I think (but am not sure) that this started with my changing the login
> account in Windows Services for all the SQL Server entries from my domain
> account to the Local account.
> I have since completly uninstalled all SQL Servers and tools and then
> reinstalled just the SQL Server 2000 client tools. Also, my local profile
> was completly removed and I started with a fresh local account.
> Now the really bizzare stuff. I (of course) get the error when logged into
> my machine and I also get the error when logged into another machine.
> However, when our Windows sysadmin logs into my machine, he can connect
> just fine.
> I am so totally lost, it isn't funny.
>

2nd Login failed for user '(null)' ...

This is driving me NUTS!
Sometime on Modday, or the first part of the day Tuesday, I lost my ability
to connect to the servers from my workstation and have been getting the
message: "Login failed for user '(null)' ...".
I think (but am not sure) that this started with my changing the login
account in Windows Services for all the SQL Server entries from my domain
account to the Local account.
I have since completly uninstalled all SQL Servers and tools and then
reinstalled just the SQL Server 2000 client tools. Also, my local profile
was completly removed and I started with a fresh local account.
Now the really bizzare stuff. I (of course) get the error when logged into
my machine and I also get the error when logged into another machine.
However, when our Windows sysadmin logs into my machine, he can connect just
fine.
I am so totally lost, it isn't funny.OK, my version of the problem has been figured out.
The remote servers I'm dealing with are not part of the domain and we had a
new password policy (on the new QA cluster) that required two additional
characters be added. The Windows sysadmin had me change my domain password
to match - hence a password mismatch and the error.
Once I changed my password back to the old one, I was able to connect again.
Sigh ...
"Jay" <nospam@.nospam.org> wrote in message
news:unwuEGYIIHA.5360@.TK2MSFTNGP03.phx.gbl...
> This is driving me NUTS!
> Sometime on Modday, or the first part of the day Tuesday, I lost my
> ability to connect to the servers from my workstation and have been
> getting the message: "Login failed for user '(null)' ...".
> I think (but am not sure) that this started with my changing the login
> account in Windows Services for all the SQL Server entries from my domain
> account to the Local account.
> I have since completly uninstalled all SQL Servers and tools and then
> reinstalled just the SQL Server 2000 client tools. Also, my local profile
> was completly removed and I started with a fresh local account.
> Now the really bizzare stuff. I (of course) get the error when logged into
> my machine and I also get the error when logged into another machine.
> However, when our Windows sysadmin logs into my machine, he can connect
> just fine.
> I am so totally lost, it isn't funny.
>

2nd Login failed for user '(null)' ...

This is driving me NUTS!
Sometime on Modday, or the first part of the day Tuesday, I lost my ability
to connect to the servers from my workstation and have been getting the
message: "Login failed for user '(null)' ...".
I think (but am not sure) that this started with my changing the login
account in Windows Services for all the SQL Server entries from my domain
account to the Local account.
I have since completly uninstalled all SQL Servers and tools and then
reinstalled just the SQL Server 2000 client tools. Also, my local profile
was completly removed and I started with a fresh local account.
Now the really bizzare stuff. I (of course) get the error when logged into
my machine and I also get the error when logged into another machine.
However, when our Windows sysadmin logs into my machine, he can connect just
fine.
I am so totally lost, it isn't funny.OK, my version of the problem has been figured out.
The remote servers I'm dealing with are not part of the domain and we had a
new password policy (on the new QA cluster) that required two additional
characters be added. The Windows sysadmin had me change my domain password
to match - hence a password mismatch and the error.
Once I changed my password back to the old one, I was able to connect again.
Sigh ...
"Jay" <nospam@.nospam.org> wrote in message
news:unwuEGYIIHA.5360@.TK2MSFTNGP03.phx.gbl...
> This is driving me NUTS!
> Sometime on Modday, or the first part of the day Tuesday, I lost my
> ability to connect to the servers from my workstation and have been
> getting the message: "Login failed for user '(null)' ...".
> I think (but am not sure) that this started with my changing the login
> account in Windows Services for all the SQL Server entries from my domain
> account to the Local account.
> I have since completly uninstalled all SQL Servers and tools and then
> reinstalled just the SQL Server 2000 client tools. Also, my local profile
> was completly removed and I started with a fresh local account.
> Now the really bizzare stuff. I (of course) get the error when logged into
> my machine and I also get the error when logged into another machine.
> However, when our Windows sysadmin logs into my machine, he can connect
> just fine.
> I am so totally lost, it isn't funny.
>

2k5 Management Studio Object Explorer Error

Receiving the enclosed error when attempting to connect to a server and
browse. (the Object Explorer works fine when browsing 'local' server). I
have tried this with two different installagions of 2k5 with the same result
s.
Also the 'Summary' pane will allow drilling up and down.
Is there a work around'
Thanks in advance
GH
SS Version: 09.00.1187
Error Info:
TITLE: Microsoft SQL Server Management Studio
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
ADDITIONAL INFORMATION:
Insert Error: Column name or number of supplied values does not match table
definition. (Microsoft SQL Server, Error: 213)
For help, click:
http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
=============================
***** Advanced Information ***********
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Program Location:
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
sqlCommand)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
query)
at
Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(Execut
eSql execSql, String query)
at
Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollecti
on 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(SqlE
numResult sqlresult, ResultType resultType)
at
Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult
result)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult
erParent)
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.Agent.JobServer.ImplInitialize(String[
;]
fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
allProperties)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
propname)
at Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentProperty
Handler.SetTsxInformation(Server server, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentProperty
Handler.PopulateProperties(INodeInformation
source, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.P
opulateProperties()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
Builder.SetStaticProperties(NodeContext nodeContext)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
Builder.BuildDynamicItemWithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
Builder.BuildDynamicItem(IList
nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
Builder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHiera
rchyNode.BuildChildren()
===================================
Insert Error: Column name or number of supplied values does not match table
definition. (.Net SqlClient Data Provider)
For help, click:
http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
Server Name: a-rogerp-sql01
Error Number: 213
Severity: 16
State: 7
Procedure: sp_get_sqlagent_properties
Line Number: 162
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(TdsParserStateO
bjec
t
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.Common.ServerConnection.ExecuteReader(String
sqlCommand)Hi,
One possible cause of this error is that when you are connecting
remotely that you are using two different builds of SQL Server 2005.
There are incompatibilities between some builds.
Are the SQL Server 2005 builds the same on each of the machines? If
not, the workaround is to use the same build on all machines.
Andrew Watt
MVP - InfoPath
On Tue, 1 Nov 2005 12:18:04 -0800, "GH" <vakar@.community.nospam>
wrote:

>Receiving the enclosed error when attempting to connect to a server and
>browse. (the Object Explorer works fine when browsing 'local' server). I
>have tried this with two different installagions of 2k5 with the same resul
ts.
>Also the 'Summary' pane will allow drilling up and down.
>Is there a work around'
>--
>Thanks in advance
>GH
>SS Version: 09.00.1187
>Error Info:
>TITLE: Microsoft SQL Server Management Studio
>--
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>ADDITIONAL INFORMATION:
>Insert Error: Column name or number of supplied values does not match table
>definition. (Microsoft SQL Server, Error: 213)
>For help, click:
>http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
>=============================
>***** Advanced Information ***********
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>Program Location:
> at
>Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
>sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
>query)
> at
>Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(Execu
teSql execSql, String query)
> at
>Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollect
ion query, Object con, StatementBuilder sb, RetriveMode rm)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType
>resultType, StringCollection sql, Object connectionInfo, StatementBuilder s
b)
> at
>Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(Sql
EnumResult sqlresult, ResultType resultType)
> at
>Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult
>result)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult
>erParent)
> 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
1;]
>fields, OrderBy[] orderby)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[]
>fields, OrderBy[] orderby)
> at
>Microsoft.SqlServer.Management.Smo.Agent.JobServer.ImplInitialize(String
1;]
>fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
>allProperties)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
>propname)
> at Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName(
)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropert
yHandler.SetTsxInformation(Server server, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropert
yHandler.PopulateProperties(INodeInformation
>source, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.
PopulateProperties()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIte
mBuilder.SetStaticProperties(NodeContext nodeContext)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIte
mBuilder.BuildDynamicItemWithQuery(IList
>nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
>Boolean registerBuilder, Boolean registerBuiltItems)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIte
mBuilder.BuildDynamicItem(IList
>nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
>filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIte
mBuilder.Build(INodeInformation
>source, INavigableItem sourceItem, IFilterProvider filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIte
m.GetChildren()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHier
archyNode.BuildChildren()
>===================================
>Insert Error: Column name or number of supplied values does not match table
>definition. (.Net SqlClient Data Provider)
>--
>For help, click:
>http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
>--
>Server Name: a-rogerp-sql01
>Error Number: 213
>Severity: 16
>State: 7
>Procedure: sp_get_sqlagent_properties
>Line Number: 162
>
>--
>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(TdsParserStateO
bje
ct
>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.Common.ServerConnection.ExecuteReader(String
>sqlCommand)|||If you are using the RC/RTM build to connect to an earlier build like the
September CTP or earlier you'll get this error. Make sure all your
servers/tools are on the same build
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"GH" <vakar@.community.nospam> wrote in message
news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
> Receiving the enclosed error when attempting to connect to a server and
> browse. (the Object Explorer works fine when browsing 'local' server). I
> have tried this with two different installagions of 2k5 with the same
> results.
> Also the 'Summary' pane will allow drilling up and down.
> Is there a work around'
> --
> Thanks in advance
> GH
> SS Version: 09.00.1187
> Error Info:
> TITLE: Microsoft SQL Server Management Studio
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> ADDITIONAL INFORMATION:
> Insert Error: Column name or number of supplied values does not match
> table
> definition. (Microsoft SQL Server, Error: 213)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
> =============================
> ***** Advanced Information ***********
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(Strin
g
> sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
> query)
> at
> Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(Exec
uteSql
> execSql, String query)
> at
> Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollec
tion
> 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(Sq
lEnumResult
> sqlresult, ResultType resultType)
> at
> Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult
> result)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult
> erParent)
> 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.GetEnumeratorDataReade
r(Request
> req)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String&#
91;]
> fields, OrderBy[] orderby)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[
]
> fields, OrderBy[] orderby)
> at
> Microsoft.SqlServer.Management.Smo.Agent.JobServer.ImplInitialize(String&#
91;]
> fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
> allProperties)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
> propname)
> at
> Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentProper
tyHandler.SetTsxInformation(Server
> server, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentProper
tyHandler.PopulateProperties(INodeInformation
> source, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext
.PopulateProperties()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
emBuilder.SetStaticProperties(NodeContext
> nodeContext)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
emBuilder.BuildDynamicItemWithQuery(IList
> nodes, INodeInformation source, INavigableItem sourceItem, String
> urnQuery,
> Boolean registerBuilder, Boolean registerBuiltItems)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
emBuilder.BuildDynamicItem(IList
> nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
> filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
emBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
em.GetChildren()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHie
rarchyNode.BuildChildren()
> ===================================
> Insert Error: Column name or number of supplied values does not match
> table
> definition. (.Net SqlClient Data Provider)
> --
> For help, click:
> http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
> --
> Server Name: a-rogerp-sql01
> Error Number: 213
> Severity: 16
> State: 7
> Procedure: sp_get_sqlagent_properties
> Line Number: 162
>
> --
> 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(TdsParserStateO
bj
ect
> 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.Common.ServerConnection.ExecuteReader(Strin
g
> sqlCommand)
>
>
>|||Thanks Guys ..
I am connecting to Sept CTP versions ..
It appears this build (Sept CTP) has a characteristic different from the
previous ... It throws this error if the remote server has not been
registered prior to attempting the connection ...
I am continuining to test this.
Thanks for your assistance
GH
"Jasper Smith" wrote:

> If you are using the RC/RTM build to connect to an earlier build like the
> September CTP or earlier you'll get this error. Make sure all your
> servers/tools are on the same build
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "GH" <vakar@.community.nospam> wrote in message
> news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
>
>|||Hi,
How about the results of your testing? I wanted to post a quick note to see
if you would like additional assistance or information regarding this
particular issue. We appreciate your patience and look forward to hearing
from you!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Registering did the trick CTP to CTP ... although I have not figured out a
defined process.
However, Now I am trying to use the RTM Management Studio and connect to the
Object Explorer on a CTP version on another server. Same problem. The
registration trick does not work here.
--
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:

> Hi,
> How about the results of your testing? I wanted to post a quick note to se
e
> if you would like additional assistance or information regarding this
> particular issue. We appreciate your patience and look forward to hearing
> from you!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||Hi Vakar,
Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
like to recommand you replace all CTP with RTM and I believe this will fix
the imcompatible issue.
Thank you for your patience and cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||We have some CTP in semi-production ...
We will be administrating the the re-install via Remote Desktop, which is a
pain.
My understanding is we have to remove CTP before installing RTM .. that is
correct.
--
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:

> Hi Vakar,
> Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
> like to recommand you replace all CTP with RTM and I believe this will fix
> the imcompatible issue.
> Thank you for your patience and cooperation.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||Hi Vakar,
I do understand that removing and reinstalling costs much time. However, I
am afraid it is not a wise decision to deploy Community Technical Preview
version of SQL Server on production server.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

2k5 Management Studio Object Explorer Error

Receiving the enclosed error when attempting to connect to a server and
browse. (the Object Explorer works fine when browsing 'local' server). I
have tried this with two different installagions of 2k5 with the same results.
Also the 'Summary' pane will allow drilling up and down.
Is there a work around'
--
Thanks in advance
GH
SS Version: 09.00.1187
Error Info:
TITLE: Microsoft SQL Server Management Studio
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
ADDITIONAL INFORMATION:
Insert Error: Column name or number of supplied values does not match table
definition. (Microsoft SQL Server, Error: 213)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
=============================
***** Advanced Information ***********
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
Program Location:
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
sqlCommand)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
query)
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.SqlObjectBase.GetData(EnumResult
erParent)
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.Agent.JobServer.ImplInitialize(String[]
fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
allProperties)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
propname)
at Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.SetTsxInformation(Server server, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.PopulateProperties(INodeInformation
source, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.PopulateProperties()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.SetStaticProperties(NodeContext nodeContext)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()
===================================
Insert Error: Column name or number of supplied values does not match table
definition. (.Net SqlClient Data Provider)
--
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
--
Server Name: a-rogerp-sql01
Error Number: 213
Severity: 16
State: 7
Procedure: sp_get_sqlagent_properties
Line Number: 162
--
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.Common.ServerConnection.ExecuteReader(String
sqlCommand)Hi,
One possible cause of this error is that when you are connecting
remotely that you are using two different builds of SQL Server 2005.
There are incompatibilities between some builds.
Are the SQL Server 2005 builds the same on each of the machines? If
not, the workaround is to use the same build on all machines.
Andrew Watt
MVP - InfoPath
On Tue, 1 Nov 2005 12:18:04 -0800, "GH" <vakar@.community.nospam>
wrote:
>Receiving the enclosed error when attempting to connect to a server and
>browse. (the Object Explorer works fine when browsing 'local' server). I
>have tried this with two different installagions of 2k5 with the same results.
>Also the 'Summary' pane will allow drilling up and down.
>Is there a work around'
>--
>Thanks in advance
>GH
>SS Version: 09.00.1187
>Error Info:
>TITLE: Microsoft SQL Server Management Studio
>--
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>ADDITIONAL INFORMATION:
>Insert Error: Column name or number of supplied values does not match table
>definition. (Microsoft SQL Server, Error: 213)
>For help, click:
>http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
>=============================>***** Advanced Information ***********
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>Program Location:
> at
>Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
>sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
>query)
> 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.SqlObjectBase.GetData(EnumResult
>erParent)
> 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.Agent.JobServer.ImplInitialize(String[]
>fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
>allProperties)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
>propname)
> at Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.SetTsxInformation(Server server, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.PopulateProperties(INodeInformation
>source, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.PopulateProperties()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.SetStaticProperties(NodeContext nodeContext)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
>nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
>Boolean registerBuilder, Boolean registerBuiltItems)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
>nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
>filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
>source, INavigableItem sourceItem, IFilterProvider filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()
>===================================>Insert Error: Column name or number of supplied values does not match table
>definition. (.Net SqlClient Data Provider)
>--
>For help, click:
>http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
>--
>Server Name: a-rogerp-sql01
>Error Number: 213
>Severity: 16
>State: 7
>Procedure: sp_get_sqlagent_properties
>Line Number: 162
>
>--
>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.Common.ServerConnection.ExecuteReader(String
>sqlCommand)|||If you are using the RC/RTM build to connect to an earlier build like the
September CTP or earlier you'll get this error. Make sure all your
servers/tools are on the same build
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"GH" <vakar@.community.nospam> wrote in message
news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
> Receiving the enclosed error when attempting to connect to a server and
> browse. (the Object Explorer works fine when browsing 'local' server). I
> have tried this with two different installagions of 2k5 with the same
> results.
> Also the 'Summary' pane will allow drilling up and down.
> Is there a work around'
> --
> Thanks in advance
> GH
> SS Version: 09.00.1187
> Error Info:
> TITLE: Microsoft SQL Server Management Studio
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> ADDITIONAL INFORMATION:
> Insert Error: Column name or number of supplied values does not match
> table
> definition. (Microsoft SQL Server, Error: 213)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
> =============================> ***** Advanced Information ***********
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
> sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
> query)
> 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.SqlObjectBase.GetData(EnumResult
> erParent)
> 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.Agent.JobServer.ImplInitialize(String[]
> fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
> allProperties)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
> propname)
> at
> Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.SetTsxInformation(Server
> server, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.PopulateProperties(INodeInformation
> source, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.PopulateProperties()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.SetStaticProperties(NodeContext
> nodeContext)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
> nodes, INodeInformation source, INavigableItem sourceItem, String
> urnQuery,
> Boolean registerBuilder, Boolean registerBuiltItems)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
> nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
> filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()
> ===================================> Insert Error: Column name or number of supplied values does not match
> table
> definition. (.Net SqlClient Data Provider)
> --
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
> --
> Server Name: a-rogerp-sql01
> Error Number: 213
> Severity: 16
> State: 7
> Procedure: sp_get_sqlagent_properties
> Line Number: 162
>
> --
> 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.Common.ServerConnection.ExecuteReader(String
> sqlCommand)
>
>
>|||Thanks Guys ..
I am connecting to Sept CTP versions ..
It appears this build (Sept CTP) has a characteristic different from the
previous ... It throws this error if the remote server has not been
registered prior to attempting the connection ...
I am continuining to test this.
Thanks for your assistance
GH
"Jasper Smith" wrote:
> If you are using the RC/RTM build to connect to an earlier build like the
> September CTP or earlier you'll get this error. Make sure all your
> servers/tools are on the same build
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "GH" <vakar@.community.nospam> wrote in message
> news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
> > Receiving the enclosed error when attempting to connect to a server and
> > browse. (the Object Explorer works fine when browsing 'local' server). I
> > have tried this with two different installagions of 2k5 with the same
> > results.
> >
> > Also the 'Summary' pane will allow drilling up and down.
> >
> > Is there a work around'
> >
> > --
> > Thanks in advance
> > GH
> >
> > SS Version: 09.00.1187
> >
> > Error Info:
> >
> > TITLE: Microsoft SQL Server Management Studio
> > --
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > Insert Error: Column name or number of supplied values does not match
> > table
> > definition. (Microsoft SQL Server, Error: 213)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
> >
> > =============================> >
> > ***** Advanced Information ***********
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> > Program Location:
> >
> > at
> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
> > sqlCommand)
> > at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
> > query)
> > 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.SqlObjectBase.GetData(EnumResult
> > erParent)
> > 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.Agent.JobServer.ImplInitialize(String[]
> > fields, OrderBy[] orderby)
> > at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
> > allProperties)
> > at
> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
> > propname)
> > at
> > Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.SetTsxInformation(Server
> > server, INameObjectCollection properties)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.PopulateProperties(INodeInformation
> > source, INameObjectCollection properties)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.PopulateProperties()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.SetStaticProperties(NodeContext
> > nodeContext)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
> > nodes, INodeInformation source, INavigableItem sourceItem, String
> > urnQuery,
> > Boolean registerBuilder, Boolean registerBuiltItems)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
> > nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
> > filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
> > source, INavigableItem sourceItem, IFilterProvider filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()
> >
> > ===================================> >
> > Insert Error: Column name or number of supplied values does not match
> > table
> > definition. (.Net SqlClient Data Provider)
> >
> > --
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
> >
> > --
> > Server Name: a-rogerp-sql01
> > Error Number: 213
> > Severity: 16
> > State: 7
> > Procedure: sp_get_sqlagent_properties
> > Line Number: 162
> >
> >
> > --
> > 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.Common.ServerConnection.ExecuteReader(String
> > sqlCommand)
> >
> >
> >
> >
> >
> >
>
>|||Hi,
How about the results of your testing? I wanted to post a quick note to see
if you would like additional assistance or information regarding this
particular issue. We appreciate your patience and look forward to hearing
from you!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Registering did the trick CTP to CTP ... although I have not figured out a
defined process.
However, Now I am trying to use the RTM Management Studio and connect to the
Object Explorer on a CTP version on another server. Same problem. The
registration trick does not work here.
--
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:
> Hi,
> How about the results of your testing? I wanted to post a quick note to see
> if you would like additional assistance or information regarding this
> particular issue. We appreciate your patience and look forward to hearing
> from you!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Vakar,
Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
like to recommand you replace all CTP with RTM and I believe this will fix
the imcompatible issue.
Thank you for your patience and cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||We have some CTP in semi-production ...
We will be administrating the the re-install via Remote Desktop, which is a
pain.
My understanding is we have to remove CTP before installing RTM .. that is
correct.
--
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:
> Hi Vakar,
> Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
> like to recommand you replace all CTP with RTM and I believe this will fix
> the imcompatible issue.
> Thank you for your patience and cooperation.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Vakar,
I do understand that removing and reinstalling costs much time. However, I
am afraid it is not a wise decision to deploy Community Technical Preview
version of SQL Server on production server.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

2k5 Management Studio Object Explorer Error

Receiving the enclosed error when attempting to connect to a server and
browse. (the Object Explorer works fine when browsing 'local' server). I
have tried this with two different installagions of 2k5 with the same results.
Also the 'Summary' pane will allow drilling up and down.
Is there a work around?
Thanks in advance
GH
SS Version: 09.00.1187
Error Info:
TITLE: Microsoft SQL Server Management Studio
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
ADDITIONAL INFORMATION:
Insert Error: Column name or number of supplied values does not match table
definition. (Microsoft SQL Server, Error: 213)
For help, click:
http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
=============================
***** Advanced Information ***********
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Program Location:
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteReader(String
sqlCommand)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataReader(String
query)
at
Microsoft.SqlServer.Management.Smo.DataProvider.Se tConnectionAndQuery(ExecuteSql execSql, String query)
at
Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illData(ResultType
resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at
Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at
Microsoft.SqlServer.Management.Smo.SqlObjectBase.B uildResult(EnumResult
result)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.G etData(EnumResult
erParent)
at Microsoft.SqlServer.Management.Smo.Environment.Get Data()
at Microsoft.SqlServer.Management.Smo.Environment.Get Data(Request req,
Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetD ata(Object
connectionInfo, Request request)
at
Microsoft.SqlServer.Management.Smo.ExecutionManage r.GetEnumeratorDataReader(Request req)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.Ge tInitDataReader(String[]
fields, OrderBy[] orderby)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.Im plInitialize(String[]
fields, OrderBy[] orderby)
at
Microsoft.SqlServer.Management.Smo.Agent.JobServer .ImplInitialize(String[]
fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.In itialize(Boolean
allProperties)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.On PropertyMissing(String
propname)
at Microsoft.SqlServer.Management.Smo.Agent.JobServer .get_MsxServerName()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.AgentPropertyHandler.SetTsxInformatio n(Server server, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.AgentPropertyHandler.PopulateProperti es(INodeInformation
source, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NodeContext.PopulateProperties()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.SetStaticPropert ies(NodeContext nodeContext)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem WithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem (IList
nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.Build(INodeInfor mation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItem.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ExplorerHierarchyNode.BuildChildren()
===================================
Insert Error: Column name or number of supplied values does not match table
definition. (.Net SqlClient Data Provider)
For help, click:
http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
Server Name: a-rogerp-sql01
Error Number: 213
Severity: 16
State: 7
Procedure: sp_get_sqlagent_properties
Line Number: 162
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(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(Com mandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteReader(String
sqlCommand)
Hi,
One possible cause of this error is that when you are connecting
remotely that you are using two different builds of SQL Server 2005.
There are incompatibilities between some builds.
Are the SQL Server 2005 builds the same on each of the machines? If
not, the workaround is to use the same build on all machines.
Andrew Watt
MVP - InfoPath
On Tue, 1 Nov 2005 12:18:04 -0800, "GH" <vakar@.community.nospam>
wrote:

>Receiving the enclosed error when attempting to connect to a server and
>browse. (the Object Explorer works fine when browsing 'local' server). I
>have tried this with two different installagions of 2k5 with the same results.
>Also the 'Summary' pane will allow drilling up and down.
>Is there a work around?
>--
>Thanks in advance
>GH
>SS Version: 09.00.1187
>Error Info:
>TITLE: Microsoft SQL Server Management Studio
>--
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>ADDITIONAL INFORMATION:
>Insert Error: Column name or number of supplied values does not match table
>definition. (Microsoft SQL Server, Error: 213)
>For help, click:
>http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
>=============================
>***** Advanced Information ***********
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>Program Location:
> at
>Microsoft.SqlServer.Management.Common.ServerConne ction.ExecuteReader(String
>sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataReader(String
>query)
> at
>Microsoft.SqlServer.Management.Smo.DataProvider.S etConnectionAndQuery(ExecuteSql execSql, String query)
> at
>Microsoft.SqlServer.Management.Smo.ExecuteSql.Get DataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illData(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.SqlObjectBase.G etData(EnumResult
>erParent)
> at Microsoft.SqlServer.Management.Smo.Environment.Get Data()
> at Microsoft.SqlServer.Management.Smo.Environment.Get Data(Request req,
>Object ci)
> at Microsoft.SqlServer.Management.Smo.Enumerator.GetD ata(Object
>connectionInfo, Request request)
> at
>Microsoft.SqlServer.Management.Smo.ExecutionManag er.GetEnumeratorDataReader(Request req)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.G etInitDataReader(String[]
>fields, OrderBy[] orderby)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.I mplInitialize(String[]
>fields, OrderBy[] orderby)
> at
>Microsoft.SqlServer.Management.Smo.Agent.JobServe r.ImplInitialize(String[]
>fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.In itialize(Boolean
>allProperties)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.O nPropertyMissing(String
>propname)
> at Microsoft.SqlServer.Management.Smo.Agent.JobServer .get_MsxServerName()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.AgentPropertyHandler.SetTsxInformati on(Server server, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.AgentPropertyHandler.PopulatePropert ies(INodeInformation
>source, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NodeContext.PopulateProperties()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NavigableItemBuilder.SetStaticProper ties(NodeContext nodeContext)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NavigableItemBuilder.BuildDynamicIte mWithQuery(IList
>nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
>Boolean registerBuilder, Boolean registerBuiltItems)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NavigableItemBuilder.BuildDynamicIte m(IList
>nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
>filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NavigableItemBuilder.Build(INodeInfo rmation
>source, INavigableItem sourceItem, IFilterProvider filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NavigableItem.GetChildren()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.ExplorerHierarchyNode.BuildChildren( )
>===================================
>Insert Error: Column name or number of supplied values does not match table
>definition. (.Net SqlClient Data Provider)
>--
>For help, click:
>http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
>--
>Server Name: a-rogerp-sql01
>Error Number: 213
>Severity: 16
>State: 7
>Procedure: sp_get_sqlagent_properties
>Line Number: 162
>
>--
>Program Location:
> at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
>Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
>exception, Boolean breakConnection)
> at
>System.Data.SqlClient.TdsParser.ThrowExceptionAnd Warning(TdsParserStateObject
>stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
>SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
>bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()
> at System.Data.SqlClient.SqlDataReader.get_MetaData()
> at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
>RunBehavior runBehavior, String resetOptionsString)
> at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(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(Com mandBehavior
>behavior, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader()
> at
>Microsoft.SqlServer.Management.Common.ServerConne ction.ExecuteReader(String
>sqlCommand)
|||If you are using the RC/RTM build to connect to an earlier build like the
September CTP or earlier you'll get this error. Make sure all your
servers/tools are on the same build
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"GH" <vakar@.community.nospam> wrote in message
news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
> Receiving the enclosed error when attempting to connect to a server and
> browse. (the Object Explorer works fine when browsing 'local' server). I
> have tried this with two different installagions of 2k5 with the same
> results.
> Also the 'Summary' pane will allow drilling up and down.
> Is there a work around?
> --
> Thanks in advance
> GH
> SS Version: 09.00.1187
> Error Info:
> TITLE: Microsoft SQL Server Management Studio
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> ADDITIONAL INFORMATION:
> Insert Error: Column name or number of supplied values does not match
> table
> definition. (Microsoft SQL Server, Error: 213)
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
> =============================
> ***** Advanced Information ***********
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteReader(String
> sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataReader(String
> query)
> at
> Microsoft.SqlServer.Management.Smo.DataProvider.Se tConnectionAndQuery(ExecuteSql
> execSql, String query)
> at
> Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataProvider(StringCollection
> query, Object con, StatementBuilder sb, RetriveMode rm)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illData(ResultType
> resultType, StringCollection sql, Object connectionInfo, StatementBuilder
> sb)
> at
> Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illDataWithUseFailure(SqlEnumResult
> sqlresult, ResultType resultType)
> at
> Microsoft.SqlServer.Management.Smo.SqlObjectBase.B uildResult(EnumResult
> result)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.G etData(EnumResult
> erParent)
> at Microsoft.SqlServer.Management.Smo.Environment.Get Data()
> at Microsoft.SqlServer.Management.Smo.Environment.Get Data(Request req,
> Object ci)
> at Microsoft.SqlServer.Management.Smo.Enumerator.GetD ata(Object
> connectionInfo, Request request)
> at
> Microsoft.SqlServer.Management.Smo.ExecutionManage r.GetEnumeratorDataReader(Request
> req)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.Ge tInitDataReader(String[]
> fields, OrderBy[] orderby)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.Im plInitialize(String[]
> fields, OrderBy[] orderby)
> at
> Microsoft.SqlServer.Management.Smo.Agent.JobServer .ImplInitialize(String[]
> fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.In itialize(Boolean
> allProperties)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.On PropertyMissing(String
> propname)
> at
> Microsoft.SqlServer.Management.Smo.Agent.JobServer .get_MsxServerName()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.AgentPropertyHandler.SetTsxInformatio n(Server
> server, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.AgentPropertyHandler.PopulateProperti es(INodeInformation
> source, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NodeContext.PopulateProperties()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.SetStaticPropert ies(NodeContext
> nodeContext)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem WithQuery(IList
> nodes, INodeInformation source, INavigableItem sourceItem, String
> urnQuery,
> Boolean registerBuilder, Boolean registerBuiltItems)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem (IList
> nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
> filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.Build(INodeInfor mation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItem.GetChildren()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ExplorerHierarchyNode.BuildChildren()
> ===================================
> Insert Error: Column name or number of supplied values does not match
> table
> definition. (.Net SqlClient Data Provider)
> --
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
> --
> Server Name: a-rogerp-sql01
> Error Number: 213
> Severity: 16
> State: 7
> Procedure: sp_get_sqlagent_properties
> Line Number: 162
>
> --
> Program Location:
> at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()
> at System.Data.SqlClient.SqlDataReader.get_MetaData()
> at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader
> ds,
> RunBehavior runBehavior, String resetOptionsString)
> at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(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(Com mandBehavior
> behavior, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader()
> at
> Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteReader(String
> sqlCommand)
>
>
>
|||Thanks Guys ..
I am connecting to Sept CTP versions ..
It appears this build (Sept CTP) has a characteristic different from the
previous ... It throws this error if the remote server has not been
registered prior to attempting the connection ...
I am continuining to test this.
Thanks for your assistance
GH
"Jasper Smith" wrote:

> If you are using the RC/RTM build to connect to an earlier build like the
> September CTP or earlier you'll get this error. Make sure all your
> servers/tools are on the same build
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "GH" <vakar@.community.nospam> wrote in message
> news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
>
>
|||Hi,
How about the results of your testing? I wanted to post a quick note to see
if you would like additional assistance or information regarding this
particular issue. We appreciate your patience and look forward to hearing
from you!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Registering did the trick CTP to CTP ... although I have not figured out a
defined process.
However, Now I am trying to use the RTM Management Studio and connect to the
Object Explorer on a CTP version on another server. Same problem. The
registration trick does not work here.
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:

> Hi,
> How about the results of your testing? I wanted to post a quick note to see
> if you would like additional assistance or information regarding this
> particular issue. We appreciate your patience and look forward to hearing
> from you!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Vakar,
Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
like to recommand you replace all CTP with RTM and I believe this will fix
the imcompatible issue.
Thank you for your patience and cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||We have some CTP in semi-production ...
We will be administrating the the re-install via Remote Desktop, which is a
pain.
My understanding is we have to remove CTP before installing RTM .. that is
correct.
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:

> Hi Vakar,
> Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
> like to recommand you replace all CTP with RTM and I believe this will fix
> the imcompatible issue.
> Thank you for your patience and cooperation.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Vakar,
I do understand that removing and reinstalling costs much time. However, I
am afraid it is not a wise decision to deploy Community Technical Preview
version of SQL Server on production server.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

2147467259 - [DBNETLIB][ConnectionWrite (send()).]General network

I Have SQL Express installed on 17 ships. Each ship has a VB6 Client
application using OLEDB to connect to the database on local machine. Other
workstations on network also connect - we think without error. The error
above is thrown on 4 of the 17 ships. The workstations acting as the file
server are supposed to be identical (Windows XP).
We have been assured that all poer save settings on LAN Card and motherboard
have been disabled.
If I google on this error, I get over 100 hits going back several years !
Ideas to fix have included turning off connection pooling and using TCPIP
instead of Named Pipes on client workstation where database server and
application are running.
Any other ideas on what could cause this, or why 13 machines are OK, but 4
are not ? Thanks.
Mark StoryPerhaps watching this might help:
http://support.microsoft.com/kb/875285/
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
"Mark Story" <MarkStory@.discussions.microsoft.com> wrote in message
news:E02C9E86-1EF3-40CD-8487-57B18A02BFCA@.microsoft.com...
>I Have SQL Express installed on 17 ships. Each ship has a VB6 Client
> application using OLEDB to connect to the database on local machine. Other
> workstations on network also connect - we think without error. The error
> above is thrown on 4 of the 17 ships. The workstations acting as the file
> server are supposed to be identical (Windows XP).
> We have been assured that all poer save settings on LAN Card and
> motherboard
> have been disabled.
> If I google on this error, I get over 100 hits going back several years !
> Ideas to fix have included turning off connection pooling and using TCPIP
> instead of Named Pipes on client workstation where database server and
> application are running.
> Any other ideas on what could cause this, or why 13 machines are OK, but 4
> are not ? Thanks.
>
> --
> Mark Story

2006-09-13 15:24:18.07 Logon Error: 18456, Severity: 14, State: 16.

well this is a strange one.

i have a sql 2005 server express running on a pc. it has an xp embedded database on it.

i can connect to it from one pc using component database manager.

however, if i try this from another pc it fails with the following code

2006-09-13 15:24:18.07 Logon Error: 18456, Severity: 14, State: 16.
2006-09-13 15:24:18.07 Logon Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX]
.

i have simple file sharing turned of on the remote pc that fails to connect.

what is my problem.

YOu will have to disable simple filesharing at the WIndows box, because the user will be otherwise authenticated by the Guest user.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

This has been done on both db client pcs the one that failed and the one that succeded.

explorer->tools->folder options->view->Use simple file sharing checkbox.

i unchecked this checkbox.

i then rebooted the client pc.

thanks,

|||

Logon Error: 18456, Severity: 14, State: 11.

I'm using Sql server 2005 on vista.....

please give me some hints to solve the problem, thanks a lot!

Min

2006-09-13 15:24:18.07 Logon Error: 18456, Severity: 14, State: 16.

well this is a strange one.

i have a sql 2005 server express running on a pc. it has an xp embedded database on it.

i can connect to it from one pc using component database manager.

however, if i try this from another pc it fails with the following code

2006-09-13 15:24:18.07 Logon Error: 18456, Severity: 14, State: 16.
2006-09-13 15:24:18.07 Logon Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX]
.

i have simple file sharing turned of on the remote pc that fails to connect.

what is my problem.

YOu will have to disable simple filesharing at the WIndows box, because the user will be otherwise authenticated by the Guest user.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

This has been done on both db client pcs the one that failed and the one that succeded.

explorer->tools->folder options->view->Use simple file sharing checkbox.

i unchecked this checkbox.

i then rebooted the client pc.

thanks,

|||

Logon Error: 18456, Severity: 14, State: 11.

I'm using Sql server 2005 on vista.....

please give me some hints to solve the problem, thanks a lot!

Min