3197 record deleted error

HI,
i have an access MDB linked by ODBC to SQL2k.
I get a strange behaviour when i do an INSERT INTO to a local Mdb table
from "LEFT OUTER JOINED" SQL tables.
If the related table hasn't related record to the first table,
it get an Error 3167.
This behaviour is not present with MDB tables JOINS.
Who know something about this ?If you are getting an error 3167 in Access then it's likely
an access error - can't tell without the error message you
get. But that's probably the case and you would want to post
your question in an access newsgroup.
-Sue
On 27 Oct 2005 08:05:38 -0700, "merco"
<d.mercanti@.gmail.com> wrote:

>HI,
>i have an access MDB linked by ODBC to SQL2k.
>I get a strange behaviour when i do an INSERT INTO to a local Mdb table
>from "LEFT OUTER JOINED" SQL tables.
>If the related table hasn't related record to the first table,
>it get an Error 3167.
>This behaviour is not present with MDB tables JOINS.
>Who know something about this ?|||well, if i use only mdb tables this error doesn't occour.
So i suppose it's an odbc problem|||Make sure you have a primary key or unique identifier
defined for your tables you are linking. Make sure the
primary key or unique identifier is not an approximate data
type (e.g. float). Try putting on timestamp data type column
on the tables you are linking.
-Sue
On 28 Oct 2005 00:25:17 -0700, "merco"
<d.mercanti@.gmail.com> wrote:

>well, if i use only mdb tables this error doesn't occour.
>So i suppose it's an odbc problem

3197 record deleted error

HI,
i have an access MDB linked by ODBC to SQL2k.
I get a strange behaviour when i do an INSERT INTO to a local Mdb table
from "LEFT OUTER JOINED" SQL tables.
If the related table hasn't related record to the first table,
it get an Error 3167.
This behaviour is not present with MDB tables JOINS.
Who know something about this ?
If you are getting an error 3167 in Access then it's likely
an access error - can't tell without the error message you
get. But that's probably the case and you would want to post
your question in an access newsgroup.
-Sue
On 27 Oct 2005 08:05:38 -0700, "merco"
<d.mercanti@.gmail.com> wrote:

>HI,
>i have an access MDB linked by ODBC to SQL2k.
>I get a strange behaviour when i do an INSERT INTO to a local Mdb table
>from "LEFT OUTER JOINED" SQL tables.
>If the related table hasn't related record to the first table,
>it get an Error 3167.
>This behaviour is not present with MDB tables JOINS.
>Who know something about this ?
|||well, if i use only mdb tables this error doesn't occour.
So i suppose it's an odbc problem
|||Make sure you have a primary key or unique identifier
defined for your tables you are linking. Make sure the
primary key or unique identifier is not an approximate data
type (e.g. float). Try putting on timestamp data type column
on the tables you are linking.
-Sue
On 28 Oct 2005 00:25:17 -0700, "merco"
<d.mercanti@.gmail.com> wrote:

>well, if i use only mdb tables this error doesn't occour.
>So i suppose it's an odbc problem

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

2005 SP1 install, another can't authenticate...

win 2003 sp1 with sql 2005 enterprise.

Tried SA.. Tried AD Admin, tried local administrator. Set up in mixed mode so i tried windows and sql authen... I can log in normally with SA and the password and the windows admin account.

Nothing works, tried services off and on. Tried clearing everything

Reinstalled completely...

Only the SQL Server part fails because it requires authentication. All the other parts succeed.

I don't get a log since it just thinks im typing things wrong. Just this

06/06/2006 21:24:59.641 Authenticating user using Windows Authentication
06/06/2006 21:24:59.641 SQL Service MSSQLServer was previously running, ready for authentication
06/06/2006 21:24:59.641 SQL Agent Service SQLSERVERAGENT was not previously running
06/06/2006 21:24:59.782 User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
06/06/2006 21:25:07.860 Hotfix package closed

basically this is what I get and i am forced to cancel...

Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

another log, and yes its set to mixed authentication.

06/07/2006 10:08:25.416
06/07/2006 10:09:48.447 Authenticating user using Windows Authentication
06/07/2006 10:09:48.447 SQL Service MSSQLServer was previously running, ready for authentication
06/07/2006 10:09:48.447 SQL Agent Service SQLSERVERAGENT was previously running
06/07/2006 10:09:48.540 User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
06/07/2006 10:09:55.572 Authenticating user using SAPWD
06/07/2006 10:09:55.572 SQL Service MSSQLServer was previously running, ready for authentication
06/07/2006 10:09:55.572 SQL Agent Service SQLSERVERAGENT was previously running
06/07/2006 10:09:55.650 User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
06/07/2006 10:09:59.103 Hotfix package closed

and another

06/07/2006 09:09:47.704 Authenticating user using Windows Authentication
06/07/2006 09:09:47.704 SQL Service MSSQLServer was not previously running, started for authentication
06/07/2006 09:09:47.704 Attempting to start service: MSSQLServer
06/07/2006 09:09:51.579 Successfully started service: MSSQLServer
06/07/2006 09:09:51.579 SQL Agent Service SQLSERVERAGENT was not previously running
06/07/2006 09:09:51.688 User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
06/07/2006 09:09:51.688 Attempting to stop service: MSSQLServer
06/07/2006 09:09:53.688 Successfully stopped service: MSSQLServer
06/07/2006 09:10:19.470 Hotfix package closed

|||

This was a an upgrade that blew up btw and i removed everything and resinstalled.

I'm not a fan of trying to upgrade... but

I've spent many hours searching and tried profiling and I find I can't connect remotely to the server...

So profiler cannot connect and its set to allow remote connections.

I get...

'===================================

Cannot connect to SERVERNAME.

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

Login timeout expired
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 the default settings SQL Server does not allow remote connections.
(pfutil90)

Program Location:

at CProfilerSqlDbConnection.Open()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()

and this error also

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

Cannot connect to SERVERNAME.

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

Unknown error. (pfutil90)

Program Location:

at CProfilerSqlDbConnection.Open()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()

Update:

Set the trace to use TCPIP and i can connect... The default protocol isnt working for some reason... and of course i can't specify HOW to connect to apply the patch so thats why its failing.

Update:

Can connect fully to DB's from remote PC's Profiler also. So were down the "default" server protocol selection is the trouble... now im trying to find out where I set that. I

|||

still can't get connected...

played around with all the protocols. Shared memory on and off, named pipes, ip etc etc

Still no authorization.

I did get the authorization to "hang" by starting the service manually while the patch tried to authorize.

|||

I'm moving your thread to the Data Access forum. Hopefully those folks will be able to help you debug this problem.

Paul

|||

Can you clarify what is your problem now?

1) remote or local connection?
2) connection string?
3) protocols enabled on the server?
4) firewall issue? put your port number to exception if needed.

Thanks,

|||

Fixed. This actually was the native client.

I had to adjust the registry values for the native client.

|||

What did you adjust? I have the same problem.. or at least the sympoms are the same.

-jr

2005 SP1 install, another can't authenticate...

win 2003 sp1 with sql 2005 enterprise.

Tried SA.. Tried AD Admin, tried local administrator. Set up in mixed mode so i tried windows and sql authen... I can log in normally with SA and the password and the windows admin account.

Nothing works, tried services off and on. Tried clearing everything

Reinstalled completely...

Only the SQL Server part fails because it requires authentication. All the other parts succeed.

I don't get a log since it just thinks im typing things wrong. Just this

06/06/2006 21:24:59.641 Authenticating user using Windows Authentication
06/06/2006 21:24:59.641 SQL Service MSSQLServer was previously running, ready for authentication
06/06/2006 21:24:59.641 SQL Agent Service SQLSERVERAGENT was not previously running
06/06/2006 21:24:59.782 User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
06/06/2006 21:25:07.860 Hotfix package closed

basically this is what I get and i am forced to cancel...

Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

another log, and yes its set to mixed authentication.

06/07/2006 10:08:25.416
06/07/2006 10:09:48.447 Authenticating user using Windows Authentication
06/07/2006 10:09:48.447 SQL Service MSSQLServer was previously running, ready for authentication
06/07/2006 10:09:48.447 SQL Agent Service SQLSERVERAGENT was previously running
06/07/2006 10:09:48.540 User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
06/07/2006 10:09:55.572 Authenticating user using SAPWD
06/07/2006 10:09:55.572 SQL Service MSSQLServer was previously running, ready for authentication
06/07/2006 10:09:55.572 SQL Agent Service SQLSERVERAGENT was previously running
06/07/2006 10:09:55.650 User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
06/07/2006 10:09:59.103 Hotfix package closed

and another

06/07/2006 09:09:47.704 Authenticating user using Windows Authentication
06/07/2006 09:09:47.704 SQL Service MSSQLServer was not previously running, started for authentication
06/07/2006 09:09:47.704 Attempting to start service: MSSQLServer
06/07/2006 09:09:51.579 Successfully started service: MSSQLServer
06/07/2006 09:09:51.579 SQL Agent Service SQLSERVERAGENT was not previously running
06/07/2006 09:09:51.688 User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
06/07/2006 09:09:51.688 Attempting to stop service: MSSQLServer
06/07/2006 09:09:53.688 Successfully stopped service: MSSQLServer
06/07/2006 09:10:19.470 Hotfix package closed

|||

This was a an upgrade that blew up btw and i removed everything and resinstalled.

I'm not a fan of trying to upgrade... but

I've spent many hours searching and tried profiling and I find I can't connect remotely to the server...

So profiler cannot connect and its set to allow remote connections.

I get...

'===================================

Cannot connect to SERVERNAME.

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

Login timeout expired
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 the default settings SQL Server does not allow remote connections.
(pfutil90)

Program Location:

at CProfilerSqlDbConnection.Open()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()

and this error also

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

Cannot connect to SERVERNAME.

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

Unknown error. (pfutil90)

Program Location:

at CProfilerSqlDbConnection.Open()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()

Update:

Set the trace to use TCPIP and i can connect... The default protocol isnt working for some reason... and of course i can't specify HOW to connect to apply the patch so thats why its failing.

Update:

Can connect fully to DB's from remote PC's Profiler also. So were down the "default" server protocol selection is the trouble... now im trying to find out where I set that. I

|||

still can't get connected...

played around with all the protocols. Shared memory on and off, named pipes, ip etc etc

Still no authorization.

I did get the authorization to "hang" by starting the service manually while the patch tried to authorize.

|||

I'm moving your thread to the Data Access forum. Hopefully those folks will be able to help you debug this problem.

Paul

|||

Can you clarify what is your problem now?

1) remote or local connection?
2) connection string?
3) protocols enabled on the server?
4) firewall issue? put your port number to exception if needed.

Thanks,

|||

Fixed. This actually was the native client.

I had to adjust the registry values for the native client.

|||

What did you adjust? I have the same problem.. or at least the sympoms are the same.

-jr