Can't Connect

I can't connect to this new box via sql server 2000, every time I try to
register sql server to this new server, I get this message:" SQL Server does
not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
running on the new box when I connect via remote access to the box. How can
I connect? They also created a DNS, but still can't connect via sql server.
Thanks.
--
New SQL Server DBAWhat account or login are you using when you try to register sql? I'm
guessing you are trying to register the new SQL server to your Enterprise
Manager?
JD
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>I can't connect to this new box via sql server 2000, every time I try to
> register sql server to this new server, I get this message:" SQL Server
> does
> not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> running on the new box when I connect via remote access to the box. How
> can
> I connect? They also created a DNS, but still can't connect via sql
> server.
> Thanks.
> --
> New SQL Server DBA|||I am using the sa account. Yes i am using EM. Thanks.
--
New SQL Server DBA
"Joe D" wrote:

> What account or login are you using when you try to register sql? I'm
> guessing you are trying to register the new SQL server to your Enterprise
> Manager?
> JD
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>
>

Can't Connect

I can't connect to this new box via sql server 2000, every time I try to
register sql server to this new server, I get this message:" SQL Server does
not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
running on the new box when I connect via remote access to the box. How can
I connect? They also created a DNS, but still can't connect via sql server.
Thanks.
New SQL Server DBA
What account or login are you using when you try to register sql? I'm
guessing you are trying to register the new SQL server to your Enterprise
Manager?
JD
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>I can't connect to this new box via sql server 2000, every time I try to
> register sql server to this new server, I get this message:" SQL Server
> does
> not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> running on the new box when I connect via remote access to the box. How
> can
> I connect? They also created a DNS, but still can't connect via sql
> server.
> Thanks.
> --
> New SQL Server DBA
|||I am using the sa account. Yes i am using EM. Thanks.
New SQL Server DBA
"Joe D" wrote:

> What account or login are you using when you try to register sql? I'm
> guessing you are trying to register the new SQL server to your Enterprise
> Manager?
> JD
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>
>

Can't Connect

I can't connect to this new box via sql server 2000, every time I try to
register sql server to this new server, I get this message:" SQL Server does
not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
running on the new box when I connect via remote access to the box. How can
I connect? They also created a DNS, but still can't connect via sql server.
Thanks.
--
New SQL Server DBAWhat account or login are you using when you try to register sql? I'm
guessing you are trying to register the new SQL server to your Enterprise
Manager?
JD
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>I can't connect to this new box via sql server 2000, every time I try to
> register sql server to this new server, I get this message:" SQL Server
> does
> not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> running on the new box when I connect via remote access to the box. How
> can
> I connect? They also created a DNS, but still can't connect via sql
> server.
> Thanks.
> --
> New SQL Server DBA|||I am using the sa account. Yes i am using EM. Thanks.
--
New SQL Server DBA
"Joe D" wrote:
> What account or login are you using when you try to register sql? I'm
> guessing you are trying to register the new SQL server to your Enterprise
> Manager?
> JD
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
> >I can't connect to this new box via sql server 2000, every time I try to
> > register sql server to this new server, I get this message:" SQL Server
> > does
> > not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> > running on the new box when I connect via remote access to the box. How
> > can
> > I connect? They also created a DNS, but still can't connect via sql
> > server.
> > Thanks.
> > --
> > New SQL Server DBA
>
>

Cant change datatype??

Hello all,

First of all, I must state that I'm new to SQL Server, but have been a
long-time software guy for quite some time. Please excuse the potential
simplicity of the solution to my problem.

I create a blank database (TestDB) under my server machine (SQL Server 2000
Standard)... I then create a new table (Run_Number) with only one record in
it.

Field(1): Next_Run_Number (bigint), identity w/ seed 1 and increment 1, no
nulls, PK

I can successfully save this new table to disk and everything seems fine...
problem comes up when I go back into the table and change the datatype from
(bigint) to (int). I try and save changes and I get the following error
prompt:

'Run_Number' table
- Unable to create index 'PK_Run_Number'.
ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state

I've checked and there's plenty of disk space available and the dbase is set
to grow by 10% as necessary. Any ideas what could be going wrong? I'm able
to successfully make this change on my other machine running SQL Server 2000
Personal. Thoughts?

TIA!

-J.C..Hi

I don't really know why you are getting this error. Are you doing the change
directly in Enterprise Manager?
Have you tried removing the PK and setting seed to No before changing the
Datatype from bigint to int and then applied the PK and the seed again after
the change?

Be careful if you change the datatype from bigint to int as bigint values
outside the int value range obviously won't be converted correctly.

HTH, M

"J.C. Flores" <jcflores@.archonwest.com> wrote in message
news:tEm4d.517$zG1.418@.newsread3.news.pas.earthlin k.net...
> Hello all,
> First of all, I must state that I'm new to SQL Server, but have been a
> long-time software guy for quite some time. Please excuse the potential
> simplicity of the solution to my problem.
> I create a blank database (TestDB) under my server machine (SQL Server
> 2000 Standard)... I then create a new table (Run_Number) with only one
> record in it.
> Field(1): Next_Run_Number (bigint), identity w/ seed 1 and increment 1, no
> nulls, PK
> I can successfully save this new table to disk and everything seems
> fine... problem comes up when I go back into the table and change the
> datatype from (bigint) to (int). I try and save changes and I get the
> following error prompt:
> 'Run_Number' table
> - Unable to create index 'PK_Run_Number'.
> ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
> I've checked and there's plenty of disk space available and the dbase is
> set to grow by 10% as necessary. Any ideas what could be going wrong?
> I'm able to successfully make this change on my other machine running SQL
> Server 2000 Personal. Thoughts?
> TIA!
> -J.C..
>|||Yes, I'm doing this change in EM. I tried some variations re: removing PK,
disabling seed, etc... but the main point I want to convey is that I don't
have to do this type of disabling in my Personal edition of SQL Server... in
Personal edition, all I do is change bigint to int datatype and i'm able to
save without a hitch. Yet, the Standard edition is giving me problems...
same tables. And just for clarification, the table has only ONE FIELD... no
records (completely empty table).

Are we perhaps seeing issues related to permissions on the Standard edition
server? Maybe I can create tables, but for some reason can't change them
once they're created?

Ideas? I would greatly appreciate any help offered.

-J.C..

"Martin Feuersteiner" <theintrepidfox@.hotmail.com> wrote in message
news:cit885$cfa$1@.titan.btinternet.com...
> Hi
> I don't really know why you are getting this error. Are you doing the
> change directly in Enterprise Manager?
> Have you tried removing the PK and setting seed to No before changing the
> Datatype from bigint to int and then applied the PK and the seed again
> after the change?
> Be careful if you change the datatype from bigint to int as bigint values
> outside the int value range obviously won't be converted correctly.
> HTH, M
> "J.C. Flores" <jcflores@.archonwest.com> wrote in message
> news:tEm4d.517$zG1.418@.newsread3.news.pas.earthlin k.net...
>> Hello all,
>>
>> First of all, I must state that I'm new to SQL Server, but have been a
>> long-time software guy for quite some time. Please excuse the potential
>> simplicity of the solution to my problem.
>>
>> I create a blank database (TestDB) under my server machine (SQL Server
>> 2000 Standard)... I then create a new table (Run_Number) with only one
>> record in it.
>>
>> Field(1): Next_Run_Number (bigint), identity w/ seed 1 and increment 1,
>> no nulls, PK
>>
>> I can successfully save this new table to disk and everything seems
>> fine... problem comes up when I go back into the table and change the
>> datatype from (bigint) to (int). I try and save changes and I get the
>> following error prompt:
>>
>> 'Run_Number' table
>> - Unable to create index 'PK_Run_Number'.
>> ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
>>
>> I've checked and there's plenty of disk space available and the dbase is
>> set to grow by 10% as necessary. Any ideas what could be going wrong?
>> I'm able to successfully make this change on my other machine running SQL
>> Server 2000 Personal. Thoughts?
>>
>> TIA!
>>
>> -J.C..
>>
>>
>>
>>|||One thing you might try is to click the 'save change script' button in the
EM table designer and then try to run that script using Query Analyzer.
Perhaps this will help isolate the problem.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"J.C. Flores" <jcflores@.archonwest.com> wrote in message
news:UxY4d.8770$gG4.4258@.newsread1.news.pas.earthl ink.net...
> Yes, I'm doing this change in EM. I tried some variations re: removing
> PK, disabling seed, etc... but the main point I want to convey is that I
> don't have to do this type of disabling in my Personal edition of SQL
> Server... in Personal edition, all I do is change bigint to int datatype
> and i'm able to save without a hitch. Yet, the Standard edition is giving
> me problems... same tables. And just for clarification, the table has
> only ONE FIELD... no records (completely empty table).
> Are we perhaps seeing issues related to permissions on the Standard
> edition server? Maybe I can create tables, but for some reason can't
> change them once they're created?
> Ideas? I would greatly appreciate any help offered.
> -J.C..
>
> "Martin Feuersteiner" <theintrepidfox@.hotmail.com> wrote in message
> news:cit885$cfa$1@.titan.btinternet.com...
>> Hi
>>
>> I don't really know why you are getting this error. Are you doing the
>> change directly in Enterprise Manager?
>> Have you tried removing the PK and setting seed to No before changing the
>> Datatype from bigint to int and then applied the PK and the seed again
>> after the change?
>>
>> Be careful if you change the datatype from bigint to int as bigint values
>> outside the int value range obviously won't be converted correctly.
>>
>> HTH, M
>>
>> "J.C. Flores" <jcflores@.archonwest.com> wrote in message
>> news:tEm4d.517$zG1.418@.newsread3.news.pas.earthlin k.net...
>>> Hello all,
>>>
>>> First of all, I must state that I'm new to SQL Server, but have been a
>>> long-time software guy for quite some time. Please excuse the potential
>>> simplicity of the solution to my problem.
>>>
>>> I create a blank database (TestDB) under my server machine (SQL Server
>>> 2000 Standard)... I then create a new table (Run_Number) with only one
>>> record in it.
>>>
>>> Field(1): Next_Run_Number (bigint), identity w/ seed 1 and increment 1,
>>> no nulls, PK
>>>
>>> I can successfully save this new table to disk and everything seems
>>> fine... problem comes up when I go back into the table and change the
>>> datatype from (bigint) to (int). I try and save changes and I get the
>>> following error prompt:
>>>
>>> 'Run_Number' table
>>> - Unable to create index 'PK_Run_Number'.
>>> ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
>>>
>>> I've checked and there's plenty of disk space available and the dbase is
>>> set to grow by 10% as necessary. Any ideas what could be going wrong?
>>> I'm able to successfully make this change on my other machine running
>>> SQL Server 2000 Personal. Thoughts?
>>>
>>> TIA!
>>>
>>> -J.C..
>>>
>>>
>>>
>>>
>>
>>|||Hey, remove the identity seed, change the datatype, enable the
identity seed back. There is a good chance it might fix it. If not
drop table create all over since you said there are no records.
Hope this helps, Girish

Can't Administer

I am trying for the first time on this SQL server to use the FULL TEXT
SEARCH. I can successfully use it on other similar servers. When I try to
add a FULL TEXT CATALOG to a database I get this message when the wizard is
trying to do the work:
The Microsoft Search Service cannot be administered under the present
account.
I am logged in with an account in the Administrator group. The Search
Service is started. The server is itself is running with an account in the
Administrator group. I have checked and rechecked and everything I can think
of is the same as systems where I can make this work. I am likely missing
the obvious but can't find it. Any ideas.
Thanks
Tom G.
Can you verify that the MSSearch account is running under the local system
account. Has anyone modified the SQL Server service account through the
services applet in control panel as opposed to using EM? To fix this, right
click on your server in EM, select properties, click the security tab,
change it to run under the system account, bounce your SQL Server, and then
modify it again to run under a local admin account.
Also verify that no one has removed the builtin\admin account from the
system administrators role. To do this connect to your SQL Server in EM,
expand the security folder and expand the server roles node. Double click on
the system administrator role and ensure the builtin\administrators account
is present.
if not run the following in qa.
if not exists (select * from master.dbo.syslogins where
loginname = N'NT Authority\System')
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System',
N'us_english'
GO
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
GO
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Tom Groszko" <newscorrespondent@.charter.net> wrote in message
news:%238ktUtRmEHA.2504@.TK2MSFTNGP14.phx.gbl...
> I am trying for the first time on this SQL server to use the FULL TEXT
> SEARCH. I can successfully use it on other similar servers. When I try to
> add a FULL TEXT CATALOG to a database I get this message when the wizard
is
> trying to do the work:
> The Microsoft Search Service cannot be administered under the present
> account.
> I am logged in with an account in the Administrator group. The Search
> Service is started. The server is itself is running with an account in the
> Administrator group. I have checked and rechecked and everything I can
think
> of is the same as systems where I can make this work. I am likely missing
> the obvious but can't find it. Any ideas.
> Thanks
> Tom G.
>
|||I am curious as to whether this solved the problem. I am having the same
problem and can't seem to resolve. I am trying to execute
sp_fulltext_database in Query Analyzer and get the following error
.. Msg 7635 The Microsoft Search service cannot be administered under the
present user account
1) The builtin\admin account is a member of the System Administrators roles
2) The MSSearch service is running under a Local System account (Log On tab
in services). I have also tried the "This account" selection using a local
administrator account"
3) MSSQLSERVER service is running under a local admin account, changed
through EM per your instructions below. I have also tried running it under a
System Account.
4) I guess I am confused about what the correct combination for MSSearch
and SQL Server is with regards to accounts.
5) Any help would be greatly appreciated.
Thanks,
Tom Shalloe
"Hilary Cotter" wrote:

> Can you verify that the MSSearch account is running under the local system
> account. Has anyone modified the SQL Server service account through the
> services applet in control panel as opposed to using EM? To fix this, right
> click on your server in EM, select properties, click the security tab,
> change it to run under the system account, bounce your SQL Server, and then
> modify it again to run under a local admin account.
> Also verify that no one has removed the builtin\admin account from the
> system administrators role. To do this connect to your SQL Server in EM,
> expand the security folder and expand the server roles node. Double click on
> the system administrator role and ensure the builtin\administrators account
> is present.
> if not run the following in qa.
> if not exists (select * from master.dbo.syslogins where
> loginname = N'NT Authority\System')
> exec sp_grantlogin N'NT Authority\System'
> exec sp_defaultdb N'NT Authority\System', N'master'
> exec sp_defaultlanguage N'NT Authority\System',
> N'us_english'
> GO
> exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> GO
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Tom Groszko" <newscorrespondent@.charter.net> wrote in message
> news:%238ktUtRmEHA.2504@.TK2MSFTNGP14.phx.gbl...
> is
> think
>
>
|||Tom,
Is the master the default database for the BUILTIN\Administrator account as
well as a member of the Sysadmin role?
When you changed it to run under the System Account (LocalSystem) did you do
this via the Enterprise Manager's server security tab?
The Enterprise Manager code runs an internal system extended proc -
xp_updateFTSSQLAccount - when any change to the MSSQLServer account is
executed, this xp proc makes similar change to the MSSearch service as well.
You should review the following KB articles:
317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/default...b;en-us;317746
277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default...B;EN-US;277549
Regards,
John
"Shallotx" <Shallotx@.discussions.microsoft.com> wrote in message
news:35629999-FB98-4407-98C8-5307CF9EF861@.microsoft.com...
> I am curious as to whether this solved the problem. I am having the same
> problem and can't seem to resolve. I am trying to execute
> sp_fulltext_database in Query Analyzer and get the following error
> .. Msg 7635 The Microsoft Search service cannot be administered under
the
> present user account
> 1) The builtin\admin account is a member of the System Administrators
roles
> 2) The MSSearch service is running under a Local System account (Log On
tab
> in services). I have also tried the "This account" selection using a
local
> administrator account"
> 3) MSSQLSERVER service is running under a local admin account, changed
> through EM per your instructions below. I have also tried running it
under a[vbcol=seagreen]
> System Account.
> 4) I guess I am confused about what the correct combination for MSSearch
> and SQL Server is with regards to accounts.
> 5) Any help would be greatly appreciated.
> Thanks,
> Tom Shalloe
> "Hilary Cotter" wrote:
system[vbcol=seagreen]
right[vbcol=seagreen]
then[vbcol=seagreen]
click on[vbcol=seagreen]
account[vbcol=seagreen]
to[vbcol=seagreen]
wizard[vbcol=seagreen]
the[vbcol=seagreen]
missing[vbcol=seagreen]

Cannot use Enterprise Manager to browse database.

Dear.
In recently , I cannot use Enterprise Manager to browse
datase the database. Waiting are long long time.
However,when I use Query Analyzer that is ok, no problem.
Could you help me.
Thanks.Hi,
Can you please clear your Windows users profile and re- register the SQL
server.
Note: Take a beackup of profiler befire dropping.
Thanks
Hari.
MCDBA
"Raymond" <anonymous@.discussions.microsoft.com> wrote in message
news:12c9901c3f6b0$8f817990$a401280a@.phx
.gbl...
> Dear.
> In recently , I cannot use Enterprise Manager to browse
> datase the database. Waiting are long long time.
> However,when I use Query Analyzer that is ok, no problem.
> Could you help me.
> Thanks.
>|||Thanks your reply.
I want to ask ..? what is Windows users profile in SQL server.
Thanks.
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:OvAIYRr9DHA.1428@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Can you please clear your Windows users profile and re- register the SQL
> server.
> Note: Take a beackup of profiler befire dropping.
>
> Thanks
> Hari.
> MCDBA
> "Raymond" <anonymous@.discussions.microsoft.com> wrote in message
> news:12c9901c3f6b0$8f817990$a401280a@.phx
.gbl...
>

Cannot use Enterprise Manager to browse Database.

Dear all.
In recently , I cannot use Enterprise Manager to borwse the database.
Waiting are long long time.
Server not responding.
However, Use the Query Analyzer to type SQL command that is OK...No problem.
Could you help me...?
Raymond.Hi,
Have you set auto close option on that database? If yes, disable it.
thanks
GYK

Cannot use Enterprise Manager to browse Database.

Dear all.
In recently , I cannot use Enterprise Manager to borwse the database.
Waiting are long long time.
Server not responding.
However, Use the Query Analyzer to type SQL command that is OK...No problem.
Could you help me...?
Raymond.Hi,
Have you set auto close option on that database? If yes, disable it.
thanks
GYK

Cannot sync when Auto Identity Ranges Enabled?

I have been pulling my hair out with this for some time now:
I have a small db which I need to merge replicate with a number of PocketPC
devices. NT Authentication is used.
If I do not enable the automatic identity range option, the PocketPC clients
can connect without error. However, if I enable this (which I need to), the
PocketPC user gets a host of errors:
1. (Code 80004005) A call to SQL Server Reconciler failed.
2. (Code 80045007) The merge process could not retrieve article information
for publication 'Survey'
3. (Code 0) {call sp_MShelpmergearticles(?,8000000,?)}
4. (Code 4833) Could not connect to server 'SERVER1' because 'SQLAdmin' is
not defined as a remote login at the server.
SQLAdmin is our Service startup account. It is a member of the Administrator
group.
The user account being used to connect is a standard domain user account.
If I add the user to the Administrators group the process succeeds
everytime. I have checked permissions on the SQLCE folder, and snapshot
folders and AFAIK they are correct (i.e. the user has write permission).
It looks like a permission problem, but I dont know where. It seems the only
solution to this is to add the user to the Administrators group (totally
unacceptable!).
Any suggestions because I am at a complete loss?
Cheers,
James Goodman
Did you re-run your merge agent? I've had no problem using a domain user
account, particularly if set up for anonymous subscribers. Also, you should
be getting a 280xx error number back from the errors collection in the .Net
code. The MSDN site has a list that precisely defines what each of those
errors mean.
"James Goodman" <jamesATnorton-associates.co.ukREMOVE> wrote in message
news:ufn1ZWObFHA.1404@.TK2MSFTNGP09.phx.gbl...
>I have been pulling my hair out with this for some time now:
> I have a small db which I need to merge replicate with a number of
> PocketPC devices. NT Authentication is used.
> If I do not enable the automatic identity range option, the PocketPC
> clients can connect without error. However, if I enable this (which I need
> to), the PocketPC user gets a host of errors:
> 1. (Code 80004005) A call to SQL Server Reconciler failed.
> 2. (Code 80045007) The merge process could not retrieve article
> information for publication 'Survey'
> 3. (Code 0) {call sp_MShelpmergearticles(?,8000000,?)}
> 4. (Code 4833) Could not connect to server 'SERVER1' because 'SQLAdmin' is
> not defined as a remote login at the server.
> SQLAdmin is our Service startup account. It is a member of the
> Administrator group.
> The user account being used to connect is a standard domain user account.
>
> If I add the user to the Administrators group the process succeeds
> everytime. I have checked permissions on the SQLCE folder, and snapshot
> folders and AFAIK they are correct (i.e. the user has write permission).
> It looks like a permission problem, but I dont know where. It seems the
> only solution to this is to add the user to the Administrators group
> (totally unacceptable!).
>
> Any suggestions because I am at a complete loss?
> --
> Cheers,
> James Goodman
>

cannot stop SQL Server 2005 Service.

Hello,

My problem is,

I cannot stop SQL Server 2005 Service.

after "net stop sqlserver", not stop for all time.

but, I can kill process from task manager.

How can I fix this probelm ?

Environment:

OS: Windows XP SP 2

DB: SQL Server 2005 SP2, SQL Server 2005 SP2 Express Edition.

Regards,

Yoshihiro Kawabata

are you able to stop it from the services snap in?|||

Try "net stop mssqlserver /y" for default instance or "net stop mssql$<instance_name> /y" for named instance. This will force terminating any child process first before terminating sqlserver.

|||NO, I cannot stop services by Management Studio and Configuration Manager.|||

Thanks

But, I cannot stop services by 'net stop "sql server (sqlexpress)" /y '.

|||

what is the error msg u gets... is there any entry in log... is the loged in user is a privilaged user to do this... and also check you have local instance of sql server...

Madhu

|||

The correct syntax is:

net stop mssql$sqlexpress /y

Cannot show the editor for this task. Specified cast is not valid

This error is pretty persistent. I re-installed VS 2005 and SQL Server 2005 but did not help. Every time I try to open a Script Task editor it gives me the same error regardless of the project or package. DO I NEED TO REBUILD MY SYSTEM ?

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

Cannot show the editor for this task. (Microsoft Visual Studio)

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

Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)

Program Location:

at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()
at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskMainWnd.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)

-

Any help is appreciated.

Gulden

.......

have you tried re-installing ssis?|||

I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.

|||

Last couple of days I have been re-installing VS 2005 and SQL Server 2005 from scratch. This is related to a system or temp file which was created by SSIS which does not go away when these apps uninstalled.

Would anybody know if I should go ahead and rebuild my system or are there any specific files or registry items involved that I should search for?

|||

When editing scripts, VB for applications flashes for a split second and goes away. When I am running the packages on the Debug mode, I get "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for inconvenience" right away. And does not iterate through any script after that. I wonder if I have too many script tasks in the package (about 90)

Something has seriously been corrupted concerning the Script editing that no installation can fix. It is so unexplainable to me.

Any advice ?

|||

Mistery solved!

Apparently they pushed a Macromedia package to hundreds of people's computers in my workplace re-registering at least 20 dlls including vbscript.dll.

|||I am still experiencing this problem and none of the suggestions seem to work. Any help would be appreciated.|||Did you get this problem resolved?

I have the same problem on a production package that I need to run once a week. Any help is appreciated.

Pade|||

I face the same error. It was working fine - until suddenly i started getting this message "Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)"

and it doesn't go away neither the script editor opens.

Anyone who has solved this issue ?

Thanks

Cannot show the editor for this task. Specified cast is not valid

This error is pretty persistent. I re-installed VS 2005 and SQL Server 2005 but did not help. Every time I try to open a Script Task editor it gives me the same error regardless of the project or package. DO I NEED TO REBUILD MY SYSTEM ?

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

Cannot show the editor for this task. (Microsoft Visual Studio)

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

Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)

Program Location:

at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()
at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskMainWnd.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)

-

Any help is appreciated.

Gulden

.......

have you tried re-installing ssis?|||

I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.

|||

Last couple of days I have been re-installing VS 2005 and SQL Server 2005 from scratch. This is related to a system or temp file which was created by SSIS which does not go away when these apps uninstalled.

Would anybody know if I should go ahead and rebuild my system or are there any specific files or registry items involved that I should search for?

|||

When editing scripts, VB for applications flashes for a split second and goes away. When I am running the packages on the Debug mode, I get "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for inconvenience" right away. And does not iterate through any script after that. I wonder if I have too many script tasks in the package (about 90)

Something has seriously been corrupted concerning the Script editing that no installation can fix. It is so unexplainable to me.

Any advice ?

|||

Mistery solved!

Apparently they pushed a Macromedia package to hundreds of people's computers in my workplace re-registering at least 20 dlls including vbscript.dll.

|||I am still experiencing this problem and none of the suggestions seem to work. Any help would be appreciated.|||Did you get this problem resolved?

I have the same problem on a production package that I need to run once a week. Any help is appreciated.

Pade|||

I face the same error. It was working fine - until suddenly i started getting this message "Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)"

and it doesn't go away neither the script editor opens.

Anyone who has solved this issue ?

Thanks

Cannot show the editor for this task. Specified cast is not valid

This error is pretty persistent. I re-installed VS 2005 and SQL Server 2005 but did not help. Every time I try to open a Script Task editor it gives me the same error regardless of the project or package. DO I NEED TO REBUILD MY SYSTEM ?

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

Cannot show the editor for this task. (Microsoft Visual Studio)

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

Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)

Program Location:

at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()
at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskMainWnd.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)

-

Any help is appreciated.

Gulden

.......

have you tried re-installing ssis?|||

I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.

|||

Last couple of days I have been re-installing VS 2005 and SQL Server 2005 from scratch. This is related to a system or temp file which was created by SSIS which does not go away when these apps uninstalled.

Would anybody know if I should go ahead and rebuild my system or are there any specific files or registry items involved that I should search for?

|||

When editing scripts, VB for applications flashes for a split second and goes away. When I am running the packages on the Debug mode, I get "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for inconvenience" right away. And does not iterate through any script after that. I wonder if I have too many script tasks in the package (about 90)

Something has seriously been corrupted concerning the Script editing that no installation can fix. It is so unexplainable to me.

Any advice ?

|||

Mistery solved!

Apparently they pushed a Macromedia package to hundreds of people's computers in my workplace re-registering at least 20 dlls including vbscript.dll.

|||I am still experiencing this problem and none of the suggestions seem to work. Any help would be appreciated.|||Did you get this problem resolved?

I have the same problem on a production package that I need to run once a week. Any help is appreciated.

Pade
|||

I face the same error. It was working fine - until suddenly i started getting this message "Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)"

and it doesn't go away neither the script editor opens.

Anyone who has solved this issue ?

Thanks

Cannot show the editor for this task. Specified cast is not valid

This error is pretty persistent. I re-installed VS 2005 and SQL Server 2005 but did not help. Every time I try to open a Script Task editor it gives me the same error regardless of the project or package. DO I NEED TO REBUILD MY SYSTEM ?

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

Cannot show the editor for this task. (Microsoft Visual Studio)

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

Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)

Program Location:

at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()
at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskMainWnd.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)

-

Any help is appreciated.

Gulden

.......

have you tried re-installing ssis?|||

I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.

|||

Last couple of days I have been re-installing VS 2005 and SQL Server 2005 from scratch. This is related to a system or temp file which was created by SSIS which does not go away when these apps uninstalled.

Would anybody know if I should go ahead and rebuild my system or are there any specific files or registry items involved that I should search for?

|||

When editing scripts, VB for applications flashes for a split second and goes away. When I am running the packages on the Debug mode, I get "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for inconvenience" right away. And does not iterate through any script after that. I wonder if I have too many script tasks in the package (about 90)

Something has seriously been corrupted concerning the Script editing that no installation can fix. It is so unexplainable to me.

Any advice ?

|||

Mistery solved!

Apparently they pushed a Macromedia package to hundreds of people's computers in my workplace re-registering at least 20 dlls including vbscript.dll.

|||I am still experiencing this problem and none of the suggestions seem to work. Any help would be appreciated.|||Did you get this problem resolved?

I have the same problem on a production package that I need to run once a week. Any help is appreciated.

Pade|||

I face the same error. It was working fine - until suddenly i started getting this message "Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)"

and it doesn't go away neither the script editor opens.

Anyone who has solved this issue ?

Thanks