Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts

Thursday, March 29, 2012

cannot execute xp_cmdshell. Access is denied while copying data over the network

Hi,

I am having some trouble copying data over my workgroup network from my Windows 2003 Server Machine (machineA with SQL SERVER 2005) to one of my network Machine's drive(MachineB).
Here is the T-SQL code that I am trying to execute:

EXEC xp_cmdshell 'copy D:\Data\file.txt \\MachineB\Documents'

Whenever I tried to execute the above piece of code, I get the error message "Access is denied", but if I try to copy the file from the Command Prompt (cmd.exe) with the copy command, the file copies fine over the network.

I have already searched over the internet and I found out that loads of people have the same issue, and they were suggested something like this:
"Check in Services and make sure that the MSSQLServer service is run as a domain user and that domain user has rights to these network resources."

Well it sounds plausible, but I don't know what are the exact steps to do this. How do I know which user is running the MSSQL Server service? Are they referring to the user which I use to connect to my SQL Server Database engine throuhg the SQL Server Management Studio?
Also they are suggesting 'domain user', and as I said before I do not have domain network just regular simple workgroup network.

Here are some details of the user that I use to login. I generally login into my Windows 2003 Server machine with user called 'User1' and I use the same 'User1' to connect to SQL Server through the Management Studio Screen.
Should I create a user called 'User1' on my MachineB(Destination Machine)?

I would really appreciate, if someone can give me detailed steps explaning how to solve this problem.

Thank you very much once again.

Open the Surface Area Configuration Manager. Go to the features section. Make sure that xp_cmdshell is enabled. (It is turned off by default.) Then once you have enabled xp_cmdshell, make sure that the SQL Server service account has the appropriate permissions granted.|||Hi Michael,

Thank you very much for your reply. xp_cmdshell is already enabled. How do I check the permissions of SQL Server Srvice account? Is that the same account which I use to connect to SQL SERVER through Management Studio?

Thanks

|||No. It is the Windows account that the SQL Server service is running under. Specifically, you can find this within SQL Server Configuration Manager.|||

Michael Hotek wrote:

No. It is the Windows account that the SQL Server service is running under. Specifically, you can find this within SQL Server Configuration Manager.

Ok I went to the SQL SERVER Configuration Manager. Then I clicked on SQL SERVER 2005 Services in the left pane. On the right pane, it listen 5-6 services running like Intergration Service, Analysis Service, Reporting Service, and so on. One of them was SQL SERVER(MSSQLSERVER), so I think this must be the one that you were talking about. I right clicked on it-> Properties. Under the properties tab, I saw Log on as: Built-in Account (radio button) was checked and in the dropdown below it, Local System was selected. So basically the SQL Server Service is running under Local System. Now how do I figure out what user is associated with Local System?

Thank you once again for the help.Much appreciated.

|||Local system is the local machine account. That would be why you are getting an access denied on a network resource. The SID for localsystem is not valid external to the machine. In order to be able to execute that command you would need to create a Windows login and then use that login to run the SQL Server services. That login would have to have permissions on the network resource you are trying to write to.|||Thanks a lot Michael, that really makes sense .

Now for the extension based on your reply. Are there any disadvantages of using a Windows user to run the SQL Server services instead of a Local Machine account?

Thank you very very much for your prompt reply and insightful suggestion.

|||No, in fact, there are entire feature sets that you can't use in SQL Server if you are running under the localsystem account, replication being one of them. I don't run any SQL Server under a local machine account. I always run them under specific user accounts and in particular regular domain user accounts.|||I just did this and it worked like a charm. You someone already posted the answer. Go to SQL Server Configuration Manager. Right click on Sql Server, click properties and change the user account to run under a domain or local pc account. that has access to the share.

cannot execute xp_cmdshell. Access is denied while copying data over the network

Hi,

I am having some trouble copying data over my workgroup network from my Windows 2003 Server Machine (machineA with SQL SERVER 2005) to one of my network Machine's drive(MachineB).
Here is the T-SQL code that I am trying to execute:

EXEC xp_cmdshell 'copy D:\Data\file.txt \\MachineB\Documents'

Whenever I tried to execute the above piece of code, I get the error message "Access is denied", but if I try to copy the file from the Command Prompt (cmd.exe) with the copy command, the file copies fine over the network.

I have already searched over the internet and I found out that loads of people have the same issue, and they were suggested something like this:
"Check in Services and make sure that the MSSQLServer service is run as

a domain user and that domain user has rights to these network

resources."

Well it sounds plausible, but I don't know what are the exact steps to do this. How do I know which user is running the MSSQL Server service? Are they referring to the user which I use to connect to my SQL Server Database engine throuhg the SQL Server Management Studio?
Also they are suggesting 'domain user', and as I said before I do not have domain network just regular simple workgroup network.

Here are some details of the user that I use to login. I generally login into my Windows 2003 Server machine with user called 'User1' and I use the same 'User1' to connect to SQL Server through the Management Studio Screen.
Should I create a user called 'User1' on my MachineB(Destination Machine)?

I would really appreciate, if someone can give me detailed steps explaning how to solve this problem.

Thank you very much once again.Open the Surface Area Configuration Manager. Go to the features section. Make sure that xp_cmdshell is enabled. (It is turned off by default.) Then once you have enabled xp_cmdshell, make sure that the SQL Server service account has the appropriate permissions granted.|||Hi Michael,

Thank you very much for your reply. xp_cmdshell is already enabled. How do I check the permissions of SQL Server Srvice account? Is that the same account which I use to connect to SQL SERVER through Management Studio?

Thanks|||No. It is the Windows account that the SQL Server service is running under. Specifically, you can find this within SQL Server Configuration Manager.|||

Michael Hotek wrote:

No. It is the Windows account that the SQL Server service is running under. Specifically, you can find this within SQL Server Configuration Manager.

Ok I went to the SQL SERVER Configuration Manager. Then I clicked on SQL SERVER 2005 Services in the left pane. On the right pane, it listen 5-6 services running like Intergration Service, Analysis Service, Reporting Service, and so on. One of them was SQL SERVER(MSSQLSERVER), so I think this must be the one that you were talking about. I right clicked on it-> Properties. Under the properties tab, I saw Log on as: Built-in Account (radio button) was checked and in the dropdown below it, Local System was selected. So basically the SQL Server Service is running under Local System. Now how do I figure out what user is associated with Local System?

Thank you once again for the help.Much appreciated.|||Local system is the local machine account. That would be why you are getting an access denied on a network resource. The SID for localsystem is not valid external to the machine. In order to be able to execute that command you would need to create a Windows login and then use that login to run the SQL Server services. That login would have to have permissions on the network resource you are trying to write to.|||Thanks a lot Michael, that really makes sense .

Now for the extension based on your reply. Are there any disadvantages of using a Windows user to run the SQL Server services instead of a Local Machine account?

Thank you very very much for your prompt reply and insightful suggestion.|||No, in fact, there are entire feature sets that you can't use in SQL Server if you are running under the localsystem account, replication being one of them. I don't run any SQL Server under a local machine account. I always run them under specific user accounts and in particular regular domain user accounts.|||I just did this and it worked like a charm. You someone already posted the answer. Go to SQL Server Configuration Manager. Right click on Sql Server, click properties and change the user account to run under a domain or local pc account. that has access to the share.

cannot execute xp_cmdshell. Access is denied while copying data over the network

Hi,

I am havingsome trouble copying data over my workgroup network from my Windows2003 Server Machine (machineA with SQL SERVER 2005) to one of mynetwork Machine's drive(MachineB).
Here is the T-SQL code that I am trying to execute:

EXEC xp_cmdshell 'copy D:\Data\file.txt \\MachineB\Documents'

WheneverI tried to execute the above piece of code, I get the error message"Access is denied", but if I try to copy the file from the CommandPrompt (cmd.exe) with the copy command, the file copies fine over thenetwork.

I have already searched over the internet and I foundout that loads of people have the same issue, and they were suggestedsomething like this:
"Check in Services and make sure that the MSSQLServer service is run asa domain user and that domain user has rights to these networkresources."

Wellit sounds plausible, but I don't know what are the exact steps to dothis. How do I know which user is running the MSSQL Server service? Arethey referring to the user which I use to connect to my SQL ServerDatabase engine throuhg the SQL Server Management Studio?
Also they are suggesting 'domain user', and as I said before I do not have domain network just regular simple workgroup network.

Hereare some details of the user that I use to login. I generally logininto my Windows 2003 Server machine with user called 'User1' and I usethe same 'User1' to connect to SQL Server through the Management StudioScreen.
Should I create a user called 'User1' on my MachineB(Destination Machine)?

I would really appreciate, if someone can give me detailed steps explaning how to solve this problem.

Thank you very much once again.Check out the SQL Server Surface Area Configuration under SQL Server 2005 configuration. xp_cmdshell is disabled by default. You need to enable it manually and give permissions.|||

ndinakar:

Check out the SQL Server Surface Area Configuration under SQL Server 2005 configuration. xp_cmdshell is disabled by default. You need to enable it manually and give permissions.

Thank you very much for your reply. xp_cmdshell is already enabled.

|||

modest:

"Check in Services and make sure that the MSSQLServer service is run as a domain user and that domain user has rights to these network resources."

Well it sounds plausible, but I don't know what are the exact steps to do this.

You're on the rigth waySmile goto Start->All Programs->Microsoft SQL Server2005-> Configuration Tools->SQL Server Configuration Manager->SQL Server 2005 Services->locate the service for the SQL2005 instance, should be "SQL Server (InstanceName)"->double click it-> on the Log On tab, you can see the start up account for the service. Just make sure this account has proper permission on the remote resource.

|||Yeah I did that and it says under buit-in account, the user is Local System. Now how do I find out which user is associated with Local System.

Thanks for the reply.|||

modest:

Yeah I did that and it says under buit-in account, the user is Local System. Now how do I find out which user is associated with Local System.

Thanks for the reply.

xp_cmdshell runs with SQL Server Agent permissions Microsoft have finally documented the permission requirements. Try the link below and follow the instructions. Hope this helps.

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

|||

Caddre:

modest:

Yeah I did that and it says under buit-in account, the user is Local System. Now how do I find out which user is associated with Local System.

Thanks for the reply.

xp_cmdshell runs with SQL Server Agent permissions Microsoft have finally documented the permission requirements. Try the link below and follow the instructions. Hope this helps.

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

Well I already have the proxy credential created for the User1 Windows account as I use that credential to execute the dtsRun command from the xp_cmdshell and that runs fine. The problem is when I am trying to copy something over the network. For example I can copy a file within my local machine by using the xp_cmdshell stored procedure, but it won;t work if the destination drive is a network drive.|||That is because you installed SQL Server with the local systems account when you do that and most developers do, SQL Server service and SQL Server Agent are without access to network resources. Try running replication service and you will see what I am talking about. Run a search for local systems account limitations in SQL Server BOL (books online). Hope this helps.|||

Caddre:

That is because you installed SQL Server with the local systems account when you do that and most developers do, SQL Server service and SQL Server Agent are without access to network resources. Try running replication service and you will see what I am talking about. Run a search for local systems account limitations in SQL Server BOL (books online). Hope this helps.

Thanks. Actually I was worried, if changing the startup user for SQLSERVER 2005 will affect my ASP/ASP.NET scripts or for that matter IIS6.0. Will this change be transparent to all the users on the machineand the other machine on my network which connect to the SQL SERVER onmy machine?|||It is not complicated just run full backup of all your databases and rerun setup and make sure you install SQL Server service and SQL Server Agent with two Domain accounts with network permissions. And no it will not affect your application if you do the above because if you run into permissions problem your backup will help if recreate the databases before the changes. But I don't think it will affect anything because you are just giving SQL Server service and the Agent network access. Hope this helps.|||

Caddre:

It is not complicated just run full backup of all your databases and rerun setup and make sure you install SQL Server service and SQL Server Agent with two Domain accounts with network permissions. And no it will not affect your application if you do the above because if you run into permissions problem your backup will help if recreate the databases before the changes. But I don't think it will affect anything because you are just giving SQL Server service and the Agent network access. Hope this helps.

Thanks Caddre very much. I just have one question based on your suggestion. What do you mean by domain accout? Do you mean like actual Domain Network on which my computer is connected? As I said in my first post, we have a workgroup network and not domain network. I know I am confusing with the word Domain. Does domain account mean, a new Windows user that I create on my machine? Or does it mean something lese?

Thank you once again.|||OK my bad create service accounts in your workgroup to run SQL Server service and SQL Server Agent and no you cannot run both on one account because the Agent can do a lot of automation in your application for you so it is good practice to run them on separate accounts. Hope this helps.

Cannot execute through ISQL

Hi,
I cannot execute ISQL query from dos prompt to one
specific MS SQL Server 2000 production machine, but works
fine with other server any reason
Please let me know ASAP
Thanks & Regards,
Mustaq
What 's the problem? Any error messages?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
news:2700c01c46271$e512d660$a301280a@.phx.gbl...
Hi,
I cannot execute ISQL query from dos prompt to one
specific MS SQL Server 2000 production machine, but works
fine with other server any reason
Please let me know ASAP
Thanks & Regards,
Mustaq
|||Hi Vyas,
It doesn't prompts me any error message. It just comes out.
Regards,
Mustaq

>--Original Message--
>What 's the problem? Any error messages?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
>news:2700c01c46271$e512d660$a301280a@.phx.gbl...
>Hi,
>I cannot execute ISQL query from dos prompt to one
>specific MS SQL Server 2000 production machine, but works
>fine with other server any reason
>Please let me know ASAP
>Thanks & Regards,
>Mustaq
>
>.
>
|||Can you show us the query and the way you are trying to run the query? Are
you running it interactively or running it from a batch, by specifying a
query or input file?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
news:2667101c4627f$d424b2c0$a401280a@.phx.gbl...
Hi Vyas,
It doesn't prompts me any error message. It just comes out.
Regards,
Mustaq

>--Original Message--
>What 's the problem? Any error messages?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
>news:2700c01c46271$e512d660$a301280a@.phx.gbl...
>Hi,
>I cannot execute ISQL query from dos prompt to one
>specific MS SQL Server 2000 production machine, but works
>fine with other server any reason
>Please let me know ASAP
>Thanks & Regards,
>Mustaq
>
>.
>
|||Vyas,
Here is the command and query..
C:\Documents and Settings\husmu02>isql -S AH_Stage -d
AH_Baseline -U sa -q "select @.@.version"
Just to let you know the back ground
Client machine is only installed with MS SQL 7.0 Client
network utility with Mdac 2.7 and configured, Server is
SQL Server 2000 SP3, which is in WAN.
I am able to do ODBC connection and run the query but not
through isql, understand isql doesnot make use of ODBC.
Initially I was thinking to be network problem, but may
not be true, I installed MS SQL Query Analyser from 7.0
release, I can execute the query from Query Analyser
Same command and query if I specify to another MS SQL
server 2000 it works fine.
Any reason on this issue.
And can let me know how does isql work, which ports, dlls
or drivers.
Regards,
Mustaq
Regards,
Mustaq

>--Original Message--
>Can you show us the query and the way you are trying to
run the query? Are
>you running it interactively or running it from a batch,
by specifying a
>query or input file?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
>news:2667101c4627f$d424b2c0$a401280a@.phx.gbl...
>Hi Vyas,
>It doesn't prompts me any error message. It just comes
out.
>Regards,
>Mustaq
>
>
>.
>
|||Without any error messages, it is difficult to predict what's going on, but
can you try OSQL instead, and let me know how it goes?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
news:26d5001c462fa$7c5d1e80$a501280a@.phx.gbl...
Vyas,
Here is the command and query..
C:\Documents and Settings\husmu02>isql -S AH_Stage -d
AH_Baseline -U sa -q "select @.@.version"
Just to let you know the back ground
Client machine is only installed with MS SQL 7.0 Client
network utility with Mdac 2.7 and configured, Server is
SQL Server 2000 SP3, which is in WAN.
I am able to do ODBC connection and run the query but not
through isql, understand isql doesnot make use of ODBC.
Initially I was thinking to be network problem, but may
not be true, I installed MS SQL Query Analyser from 7.0
release, I can execute the query from Query Analyser
Same command and query if I specify to another MS SQL
server 2000 it works fine.
Any reason on this issue.
And can let me know how does isql work, which ports, dlls
or drivers.
Regards,
Mustaq
Regards,
Mustaq

>--Original Message--
>Can you show us the query and the way you are trying to
run the query? Are
>you running it interactively or running it from a batch,
by specifying a
>query or input file?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
>news:2667101c4627f$d424b2c0$a401280a@.phx.gbl...
>Hi Vyas,
>It doesn't prompts me any error message. It just comes
out.
>Regards,
>Mustaq
>
>
>.
>
|||Vyas,
Thanks, got resolved by setting TCP/IP and configuring it.
Regards,
Mustaq

>--Original Message--
>Without any error messages, it is difficult to predict
what's going on, but[vbcol=seagreen]
>can you try OSQL instead, and let me know how it goes?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
>news:26d5001c462fa$7c5d1e80$a501280a@.phx.gbl...
>Vyas,
>Here is the command and query..
>C:\Documents and Settings\husmu02>isql -S AH_Stage -d
>AH_Baseline -U sa -q "select @.@.version"
>Just to let you know the back ground
>Client machine is only installed with MS SQL 7.0 Client
>network utility with Mdac 2.7 and configured, Server is
>SQL Server 2000 SP3, which is in WAN.
>I am able to do ODBC connection and run the query but not
>through isql, understand isql doesnot make use of ODBC.
>Initially I was thinking to be network problem, but may
>not be true, I installed MS SQL Query Analyser from 7.0
>release, I can execute the query from Query Analyser
>Same command and query if I specify to another MS SQL
>server 2000 it works fine.
>Any reason on this issue.
>And can let me know how does isql work, which ports, dlls
>or drivers.
>Regards,
>Mustaq
>Regards,
>Mustaq
>run the query? Are
>by specifying a
>out.
works
>
>.
>

Thursday, March 22, 2012

cannot delete publication

We are using SQL Server 2005 Service Pack 2 on WIn2003.
We lost our distributor and I reinstall SQL Server in Distributor machine.
Now I am not able to delete publication and subscription from publisher and
subscriber.
Any help highly appreciated.
tried
sp_removedbreplication
Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line 27
Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for
replication.
Thanks
Or I get following error
OLE DB provider "SQLNCLI" for linked server "repl_distributor" returned
message "Communication link failure".
Msg 233, Level 16, State 1, Line 0
Named Pipes Provider: No process is on the other end of the pipe.
"Sandeep Shankar" <sandeeps@.dntg.net> wrote in message
news:%23t%23jvCv0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> We are using SQL Server 2005 Service Pack 2 on WIn2003.
> We lost our distributor and I reinstall SQL Server in Distributor machine.
> Now I am not able to delete publication and subscription from publisher
and
> subscriber.
> Any help highly appreciated.
>
> tried
> sp_removedbreplication
> Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line
27
> Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for
> replication.
>
> Thanks
>
|||set the ignore_distributor =1 parameter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sandeep Shankar" <sandeeps@.dntg.net> wrote in message
news:%234MijUv0HHA.4004@.TK2MSFTNGP05.phx.gbl...
> Or I get following error
> OLE DB provider "SQLNCLI" for linked server "repl_distributor" returned
> message "Communication link failure".
> Msg 233, Level 16, State 1, Line 0
> Named Pipes Provider: No process is on the other end of the pipe.
>
>
>
>
> "Sandeep Shankar" <sandeeps@.dntg.net> wrote in message
> news:%23t%23jvCv0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> and
> 27
>
|||I did put this parameter yesterday, but Now when I refresh 'Local
Publication' I get ' Failed to retrive data for this request.'
More info
A exception occurred while executing a transact- sql statement or batch
Lock request time out period exceeded
Thanks
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OPzWNA30HHA.4184@.TK2MSFTNGP06.phx.gbl...[vbcol=seagreen]
> set the ignore_distributor =1 parameter
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Sandeep Shankar" <sandeeps@.dntg.net> wrote in message
> news:%234MijUv0HHA.4004@.TK2MSFTNGP05.phx.gbl...
Line
>
|||You are getting some deadlocking occurring. Run dbcc opentran and see if
there are open transaction. evaluate whether you can kill them. Close down
all instance of EM, stop the agents and try again.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sandeep Shankar" <sandeeps@.dntg.net> wrote in message
news:ez9U3y40HHA.4652@.TK2MSFTNGP05.phx.gbl...
>I did put this parameter yesterday, but Now when I refresh 'Local
> Publication' I get ' Failed to retrive data for this request.'
> More info
> A exception occurred while executing a transact- sql statement or batch
> Lock request time out period exceeded
> Thanks
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OPzWNA30HHA.4184@.TK2MSFTNGP06.phx.gbl...
> Line
>

Tuesday, March 20, 2012

Cannot Create System DSN

Hi,
I'm having some difficulty creating a system DSN on a
win2K machine for connecting to a SQL 2000 server. I'm not
sure if this may be a better question for the windows
group, but... Anyway, when I go through the odbc setup in
windows, the DSN does not appear in the list of system
dsn's that are already created. I begin to create it, and
it says it already exists, "overwrite?". (this is because
I have already tried creating it with that name, and am
using the same dsn name. If I use a new name, I don't get
the "already exists" message, but the following problem
still occurs.) I do so, and continue through creating the
dsn and successfully testing the connection. When I
finish the creation, the dsn name still does not appear in
the list of system dsn's. Is this a corrupt odbc database
on the win2K machine? I have no idea!!! PS I am tryiing
to create it with local Administrator priveledges.
Any help would be appreciated.
Thanks
David
Check the permissions on the following registry key:
HKLM\Software\ODBC\ODBC.INI
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I'm also experiencing the same problem. I've checked the permissions on the related key in the registry, and have given Full Permission to all users, but to no avail. Any other suggestions?
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Cannot Create System DSN

Hi,
I'm having some difficulty creating a system DSN on a
win2K machine for connecting to a SQL 2000 server. I'm not
sure if this may be a better question for the windows
group, but... Anyway, when I go through the odbc setup in
windows, the DSN does not appear in the list of system
dsn's that are already created. I begin to create it, and
it says it already exists, "overwrite?". (this is because
I have already tried creating it with that name, and am
using the same dsn name. If I use a new name, I don't get
the "already exists" message, but the following problem
still occurs.) I do so, and continue through creating the
dsn and successfully testing the connection. When I
finish the creation, the dsn name still does not appear in
the list of system dsn's. Is this a corrupt odbc database
on the win2K machine? I have no idea!!! PS I am tryiing
to create it with local Administrator priveledges.
Any help would be appreciated.
Thanks
DavidCheck the permissions on the following registry key:
HKLM\Software\ODBC\ODBC.INI
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I'm also experiencing the same problem. I've checked the permissions on the
related key in the registry, and have given Full Permission to all users, bu
t to no avail. Any other suggestions?
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...

Sunday, March 11, 2012

Cannot create diagram and not run jobs with my domain account logi

Hi!
I'm using SQL Server 2005 Dev. Ed. on a local machine. I'm logging in with
my domain account (HIK\Tommy) wich is a member of the Administrators group on
my computer and there is a corresponding Windows login account with sysadmin
permissions in SQL Server.
I can do most things with that account, BUT when I try to create a diagram
to a database. SQL does not like the owner of the database (my domain
account)
This is the error message that show up:
"Database diagram support objects cannot be installed because this database
does not have a valid owner. To continue, first use the Files page of the
Database Properties dialog box or ALTER AUTHORIZATION statement to set the
database owner to a valid login, then add the database diagram support
objects."
Again when I try to run a job that is owned by my domain account (HIK\Tommy)
Following message arise:
"The job failed. Unable to determine if the owner (HIK\Tommy) of job
MaintenancePlan2 has server access (reason: Could not obtain information
about Windows NT group/user 'HIK\Tommy', error code 0xea. [SQLSTATE 42000]
(Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error
3621))."
I would be very grateful if you could come up with some suggestions.
Regards
TommyThis might be due to a mismatch between the 'dbo' user mapping and the
actual database owner. You can correct this with sp_changedbowner:
USE MyDatabase
EXEC sp_changedbowner 'HIK\Tommy'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Tommy" <Tommy@.discussions.microsoft.com> wrote in message
news:72BBE688-4C5D-4472-8404-513522E803A1@.microsoft.com...
> Hi!
> I'm using SQL Server 2005 Dev. Ed. on a local machine. I'm logging in with
> my domain account (HIK\Tommy) wich is a member of the Administrators group
> on
> my computer and there is a corresponding Windows login account with
> sysadmin
> permissions in SQL Server.
> I can do most things with that account, BUT when I try to create a diagram
> to a database. SQL does not like the owner of the database (my domain
> account)
> This is the error message that show up:
> "Database diagram support objects cannot be installed because this
> database
> does not have a valid owner. To continue, first use the Files page of the
> Database Properties dialog box or ALTER AUTHORIZATION statement to set the
> database owner to a valid login, then add the database diagram support
> objects."
> Again when I try to run a job that is owned by my domain account
> (HIK\Tommy)
> Following message arise:
> "The job failed. Unable to determine if the owner (HIK\Tommy) of job
> MaintenancePlan2 has server access (reason: Could not obtain information
> about Windows NT group/user 'HIK\Tommy', error code 0xea. [SQLSTATE 42000]
> (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error
> 3621))."
> I would be very grateful if you could come up with some suggestions.
> Regards
> Tommy|||Thanks for your suggestion but it does not work.
USE MyDatabase
EXEC sp_changedbowner 'HIK\Tommy'
doesn't change anything.
On the other hand it 's possible to change user to sa and everything works
OK, so it's my domain name that is the trouble. Have never had this problem i
SQL Server 2K.
/Tommy
"Dan Guzman" wrote:
> This might be due to a mismatch between the 'dbo' user mapping and the
> actual database owner. You can correct this with sp_changedbowner:
> USE MyDatabase
> EXEC sp_changedbowner 'HIK\Tommy'
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Tommy" <Tommy@.discussions.microsoft.com> wrote in message
> news:72BBE688-4C5D-4472-8404-513522E803A1@.microsoft.com...
> > Hi!
> > I'm using SQL Server 2005 Dev. Ed. on a local machine. I'm logging in with
> > my domain account (HIK\Tommy) wich is a member of the Administrators group
> > on
> > my computer and there is a corresponding Windows login account with
> > sysadmin
> > permissions in SQL Server.
> >
> > I can do most things with that account, BUT when I try to create a diagram
> > to a database. SQL does not like the owner of the database (my domain
> > account)
> >
> > This is the error message that show up:
> > "Database diagram support objects cannot be installed because this
> > database
> > does not have a valid owner. To continue, first use the Files page of the
> > Database Properties dialog box or ALTER AUTHORIZATION statement to set the
> > database owner to a valid login, then add the database diagram support
> > objects."
> >
> > Again when I try to run a job that is owned by my domain account
> > (HIK\Tommy)
> >
> > Following message arise:
> >
> > "The job failed. Unable to determine if the owner (HIK\Tommy) of job
> > MaintenancePlan2 has server access (reason: Could not obtain information
> > about Windows NT group/user 'HIK\Tommy', error code 0xea. [SQLSTATE 42000]
> > (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error
> > 3621))."
> >
> > I would be very grateful if you could come up with some suggestions.
> >
> > Regards
> > Tommy
>
>|||My apologies but I misread your post. I guess I should a finished my coffee
first :-)
For your first issue, the database needs to be in 90 compatibility mode in
order to create diagrams.
Regarding your second problem, run the SQL Server Configuration utility to
make sure the SQL Agent isn't running under the Network Service account.
Use a domain account.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Tommy" <Tommy@.discussions.microsoft.com> wrote in message
news:753C2D7A-C719-4B67-8CCD-0E3A03A9B8D5@.microsoft.com...
> Thanks for your suggestion but it does not work.
> USE MyDatabase
> EXEC sp_changedbowner 'HIK\Tommy'
> doesn't change anything.
> On the other hand it 's possible to change user to sa and everything works
> OK, so it's my domain name that is the trouble. Have never had this
> problem i
> SQL Server 2K.
> /Tommy
> "Dan Guzman" wrote:
>> This might be due to a mismatch between the 'dbo' user mapping and the
>> actual database owner. You can correct this with sp_changedbowner:
>> USE MyDatabase
>> EXEC sp_changedbowner 'HIK\Tommy'
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Tommy" <Tommy@.discussions.microsoft.com> wrote in message
>> news:72BBE688-4C5D-4472-8404-513522E803A1@.microsoft.com...
>> > Hi!
>> > I'm using SQL Server 2005 Dev. Ed. on a local machine. I'm logging in
>> > with
>> > my domain account (HIK\Tommy) wich is a member of the Administrators
>> > group
>> > on
>> > my computer and there is a corresponding Windows login account with
>> > sysadmin
>> > permissions in SQL Server.
>> >
>> > I can do most things with that account, BUT when I try to create a
>> > diagram
>> > to a database. SQL does not like the owner of the database (my domain
>> > account)
>> >
>> > This is the error message that show up:
>> > "Database diagram support objects cannot be installed because this
>> > database
>> > does not have a valid owner. To continue, first use the Files page of
>> > the
>> > Database Properties dialog box or ALTER AUTHORIZATION statement to set
>> > the
>> > database owner to a valid login, then add the database diagram support
>> > objects."
>> >
>> > Again when I try to run a job that is owned by my domain account
>> > (HIK\Tommy)
>> >
>> > Following message arise:
>> >
>> > "The job failed. Unable to determine if the owner (HIK\Tommy) of job
>> > MaintenancePlan2 has server access (reason: Could not obtain
>> > information
>> > about Windows NT group/user 'HIK\Tommy', error code 0xea. [SQLSTATE
>> > 42000]
>> > (Error 15404) The statement has been terminated. [SQLSTATE 01000]
>> > (Error
>> > 3621))."
>> >
>> > I would be very grateful if you could come up with some suggestions.
>> >
>> > Regards
>> > Tommy
>>|||Using a domain account for the Agent and SQL Server service solves the
problem with recognizeing job owner as my domain login (HIK\Tommy), but it
still don't like my domain login as database owner when trying to create a
diagram.
My administrator don't want me to use a domain account for services for
security reasons so, I'm going to use a workaround, e.g. use sa as owner
until this bug (?) is fixed.
Thank's anyway
Tommy
"Dan Guzman" wrote:
> My apologies but I misread your post. I guess I should a finished my coffee
> first :-)
> For your first issue, the database needs to be in 90 compatibility mode in
> order to create diagrams.
> Regarding your second problem, run the SQL Server Configuration utility to
> make sure the SQL Agent isn't running under the Network Service account.
> Use a domain account.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Tommy" <Tommy@.discussions.microsoft.com> wrote in message
> news:753C2D7A-C719-4B67-8CCD-0E3A03A9B8D5@.microsoft.com...
> > Thanks for your suggestion but it does not work.
> >
> > USE MyDatabase
> > EXEC sp_changedbowner 'HIK\Tommy'
> >
> > doesn't change anything.
> >
> > On the other hand it 's possible to change user to sa and everything works
> > OK, so it's my domain name that is the trouble. Have never had this
> > problem i
> > SQL Server 2K.
> >
> > /Tommy
> >
> > "Dan Guzman" wrote:
> >
> >> This might be due to a mismatch between the 'dbo' user mapping and the
> >> actual database owner. You can correct this with sp_changedbowner:
> >>
> >> USE MyDatabase
> >> EXEC sp_changedbowner 'HIK\Tommy'
> >>
> >> --
> >> Hope this helps.
> >>
> >> Dan Guzman
> >> SQL Server MVP
> >>
> >> "Tommy" <Tommy@.discussions.microsoft.com> wrote in message
> >> news:72BBE688-4C5D-4472-8404-513522E803A1@.microsoft.com...
> >> > Hi!
> >> > I'm using SQL Server 2005 Dev. Ed. on a local machine. I'm logging in
> >> > with
> >> > my domain account (HIK\Tommy) wich is a member of the Administrators
> >> > group
> >> > on
> >> > my computer and there is a corresponding Windows login account with
> >> > sysadmin
> >> > permissions in SQL Server.
> >> >
> >> > I can do most things with that account, BUT when I try to create a
> >> > diagram
> >> > to a database. SQL does not like the owner of the database (my domain
> >> > account)
> >> >
> >> > This is the error message that show up:
> >> > "Database diagram support objects cannot be installed because this
> >> > database
> >> > does not have a valid owner. To continue, first use the Files page of
> >> > the
> >> > Database Properties dialog box or ALTER AUTHORIZATION statement to set
> >> > the
> >> > database owner to a valid login, then add the database diagram support
> >> > objects."
> >> >
> >> > Again when I try to run a job that is owned by my domain account
> >> > (HIK\Tommy)
> >> >
> >> > Following message arise:
> >> >
> >> > "The job failed. Unable to determine if the owner (HIK\Tommy) of job
> >> > MaintenancePlan2 has server access (reason: Could not obtain
> >> > information
> >> > about Windows NT group/user 'HIK\Tommy', error code 0xea. [SQLSTATE
> >> > 42000]
> >> > (Error 15404) The statement has been terminated. [SQLSTATE 01000]
> >> > (Error
> >> > 3621))."
> >> >
> >> > I would be very grateful if you could come up with some suggestions.
> >> >
> >> > Regards
> >> > Tommy
> >>
> >>
> >>
>
>|||> My administrator don't want me to use a domain account for services for
> security reasons so, I'm going to use a workaround, e.g. use sa as owner
> until this bug (?) is fixed.
The Books Online (Setting up Windows Accounts) states that it is best is to
use minimally privileged accounts for services. If you don't want to use a
low privilege domain user, you can use a (minimally privileged) local
Windows user account. I don't think this a a bug, it's just that SQL 2005
is more secure out-of-the-box so additional configuration work is needed to
loosen up security according to your organization's security policies.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Tommy" <Tommy@.discussions.microsoft.com> wrote in message
news:ED165CD9-5A84-4D4F-AC22-BF57C87A1A16@.microsoft.com...
> Using a domain account for the Agent and SQL Server service solves the
> problem with recognizeing job owner as my domain login (HIK\Tommy), but it
> still don't like my domain login as database owner when trying to create a
> diagram.
> My administrator don't want me to use a domain account for services for
> security reasons so, I'm going to use a workaround, e.g. use sa as owner
> until this bug (?) is fixed.
> Thank's anyway
> Tommy
> "Dan Guzman" wrote:
>> My apologies but I misread your post. I guess I should a finished my
>> coffee
>> first :-)
>> For your first issue, the database needs to be in 90 compatibility mode
>> in
>> order to create diagrams.
>> Regarding your second problem, run the SQL Server Configuration utility
>> to
>> make sure the SQL Agent isn't running under the Network Service account.
>> Use a domain account.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Tommy" <Tommy@.discussions.microsoft.com> wrote in message
>> news:753C2D7A-C719-4B67-8CCD-0E3A03A9B8D5@.microsoft.com...
>> > Thanks for your suggestion but it does not work.
>> >
>> > USE MyDatabase
>> > EXEC sp_changedbowner 'HIK\Tommy'
>> >
>> > doesn't change anything.
>> >
>> > On the other hand it 's possible to change user to sa and everything
>> > works
>> > OK, so it's my domain name that is the trouble. Have never had this
>> > problem i
>> > SQL Server 2K.
>> >
>> > /Tommy
>> >
>> > "Dan Guzman" wrote:
>> >
>> >> This might be due to a mismatch between the 'dbo' user mapping and the
>> >> actual database owner. You can correct this with sp_changedbowner:
>> >>
>> >> USE MyDatabase
>> >> EXEC sp_changedbowner 'HIK\Tommy'
>> >>
>> >> --
>> >> Hope this helps.
>> >>
>> >> Dan Guzman
>> >> SQL Server MVP
>> >>
>> >> "Tommy" <Tommy@.discussions.microsoft.com> wrote in message
>> >> news:72BBE688-4C5D-4472-8404-513522E803A1@.microsoft.com...
>> >> > Hi!
>> >> > I'm using SQL Server 2005 Dev. Ed. on a local machine. I'm logging
>> >> > in
>> >> > with
>> >> > my domain account (HIK\Tommy) wich is a member of the Administrators
>> >> > group
>> >> > on
>> >> > my computer and there is a corresponding Windows login account with
>> >> > sysadmin
>> >> > permissions in SQL Server.
>> >> >
>> >> > I can do most things with that account, BUT when I try to create a
>> >> > diagram
>> >> > to a database. SQL does not like the owner of the database (my
>> >> > domain
>> >> > account)
>> >> >
>> >> > This is the error message that show up:
>> >> > "Database diagram support objects cannot be installed because this
>> >> > database
>> >> > does not have a valid owner. To continue, first use the Files page
>> >> > of
>> >> > the
>> >> > Database Properties dialog box or ALTER AUTHORIZATION statement to
>> >> > set
>> >> > the
>> >> > database owner to a valid login, then add the database diagram
>> >> > support
>> >> > objects."
>> >> >
>> >> > Again when I try to run a job that is owned by my domain account
>> >> > (HIK\Tommy)
>> >> >
>> >> > Following message arise:
>> >> >
>> >> > "The job failed. Unable to determine if the owner (HIK\Tommy) of
>> >> > job
>> >> > MaintenancePlan2 has server access (reason: Could not obtain
>> >> > information
>> >> > about Windows NT group/user 'HIK\Tommy', error code 0xea. [SQLSTATE
>> >> > 42000]
>> >> > (Error 15404) The statement has been terminated. [SQLSTATE 01000]
>> >> > (Error
>> >> > 3621))."
>> >> >
>> >> > I would be very grateful if you could come up with some suggestions.
>> >> >
>> >> > Regards
>> >> > Tommy
>> >>
>> >>
>> >>
>>

Cannot create database on drive other than OS drive?

I'm trying to migrate a SQL Server 2000 database to a SQL Server 2005
machine and am having difficulties.
The new server (Server 200303) has two drives, C and E. The OS is installed
on C, but there is limited space, so I want to put the data files on E.
To migrate the database from the SQL 2000 machine, I tried both a manuak
detach/attach and the Copy Database feature. When I attempt to tell the new
server to put the data files on drive E, it tells me that it's an invalid
path. To add to the confusion, if I try to alter the "database default
location" from the server's Properties dialog, it shows only a C drive.
I then uninstalled SQL Server 2005 from the C drive and reinstalled it, this
time putting all components that I could change the target path for on the E
drive. The install was successful, the folders were created properly, along
with the master, model, msdb, etc. databases on the E drive. However, when
I try to change a database's file location or alter the default database
location, it still insists that only the C drive is available and that
anything referring to the E drive is invalid.
I tried migrating the database to another SQL 2000 machine and putting it on
a separate data drive and it works just fine.
Is there some setting that SQL Server 2005 is expecting, or some limitation
that the data files must reside on the OS install drive? I assume that I'm
just not doing something right, but I've really not done any SQL admin since
7.0 and right now I'm just trying to migrate a database to a newer, better
machine.
-ChrisChris Tacke, eMVP wrote:
> I'm trying to migrate a SQL Server 2000 database to a SQL Server 2005
> machine and am having difficulties.
> The new server (Server 200303) has two drives, C and E. The OS is installed
> on C, but there is limited space, so I want to put the data files on E.
> To migrate the database from the SQL 2000 machine, I tried both a manuak
> detach/attach and the Copy Database feature. When I attempt to tell the new
> server to put the data files on drive E, it tells me that it's an invalid
> path. To add to the confusion, if I try to alter the "database default
> location" from the server's Properties dialog, it shows only a C drive.
> I then uninstalled SQL Server 2005 from the C drive and reinstalled it, this
> time putting all components that I could change the target path for on the E
> drive. The install was successful, the folders were created properly, along
> with the master, model, msdb, etc. databases on the E drive. However, when
> I try to change a database's file location or alter the default database
> location, it still insists that only the C drive is available and that
> anything referring to the E drive is invalid.
> I tried migrating the database to another SQL 2000 machine and putting it on
> a separate data drive and it works just fine.
> Is there some setting that SQL Server 2005 is expecting, or some limitation
> that the data files must reside on the OS install drive? I assume that I'm
> just not doing something right, but I've really not done any SQL admin since
> 7.0 and right now I'm just trying to migrate a database to a newer, better
> machine.
> -Chris
>
>
Hi Chris
I assume that you have ensured that the E drive is actually working and
can be seen by the OS?
The only other thing I can think of, is that the path you have entered
for the new datafiles is wrong or doesn't exists. When you want to move
data and log files, the folder you're moving it to must already exists
otherwise it will fail.
Regards
Steen|||> I'm trying to migrate a SQL Server 2000 database to a SQL Server 2005
> machine and am having difficulties.
> The new server (Server 200303) has two drives, C and E. The OS is installed
> on C, but there is limited space, so I want to put the data files on E.
> To migrate the database from the SQL 2000 machine, I tried both a manuak
> detach/attach and the Copy Database feature. When I attempt to tell the new
> server to put the data files on drive E, it tells me that it's an invalid
> path. To add to the confusion, if I try to alter the "database default
> location" from the server's Properties dialog, it shows only a C drive.
> I then uninstalled SQL Server 2005 from the C drive and reinstalled it, this
> time putting all components that I could change the target path for on the E
> drive. The install was successful, the folders were created properly, along
> with the master, model, msdb, etc. databases on the E drive. However, when
> I try to change a database's file location or alter the default database
> location, it still insists that only the C drive is available and that
> anything referring to the E drive is invalid.
> I tried migrating the database to another SQL 2000 machine and putting it on
> a separate data drive and it works just fine.
> Is there some setting that SQL Server 2005 is expecting, or some limitation
> that the data files must reside on the OS install drive? I assume that I'm
> just not doing something right, but I've really not done any SQL admin since
> 7.0 and right now I'm just trying to migrate a database to a newer, better
> machine.
It looks like the account on which the SQL Server is running has no rights
to access the E:\ folder (and subfolders), so it does not show it nor
is able to move any files there.
Check which account you are using for the SQL Server and check effective
rights for this account to the folders you want the server to access.
Hilarion

Cannot create database

I am getting the following message while creating SQL Database on my local machine in Visual Studio:

An error has occured while establishing a connection to the server. When connecting to SQL Sever 2005, this failure may be caused by the fact that under the default settings SQL Sever does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Sever/Instance Specified)what address are you trying to connect via?

Cannot CREATE ASSEMBLY

Hi,
I am new to SQL Server 2005 but not to dotnet development. I am trying to
use the CREATE ASSEMBLY on my machine that is running the developer edition.
The ASSEMBLY keyword is not highlighted as a recognised keyword and when I
run the SQL it fails (see below). Have I not enabled something or have I
just installed it incorrectly?
CREATE ASSEMBLY
helloworld FROM 'c:\helloworld.dll'
WITH PERMISSION_SET = SAFE
Regards,
Landers
Hello landers,
Some questions first:
a.) What error message do you actually get?
b.) What are you using for a T-SQL editor?
c.) If you run xp_msver, what output do you get?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

Cannot CREATE ASSEMBLY

Hi,
I am new to SQL Server 2005 but not to dotnet development. I am trying to
use the CREATE ASSEMBLY on my machine that is running the developer edition.
The ASSEMBLY keyword is not highlighted as a recognised keyword and when I
run the SQL it fails (see below). Have I not enabled something or have I
just installed it incorrectly?
CREATE ASSEMBLY
helloworld FROM 'c:\helloworld.dll'
WITH PERMISSION_SET = SAFE
Regards,
LandersHello landers,
Some questions first:
a.) What error message do you actually get?
b.) What are you using for a T-SQL editor?
c.) If you run xp_msver, what output do you get?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

Cannot CREATE ASSEMBLY

Hi,
I am new to SQL Server 2005 but not to dotnet development. I am trying to
use the CREATE ASSEMBLY on my machine that is running the developer edition.
The ASSEMBLY keyword is not highlighted as a recognised keyword and when I
run the SQL it fails (see below). Have I not enabled something or have I
just installed it incorrectly?
CREATE ASSEMBLY
helloworld FROM 'c:\helloworld.dll'
WITH PERMISSION_SET = SAFE
Regards,
LandersHello landers,
Some questions first:
a.) What error message do you actually get?
b.) What are you using for a T-SQL editor?
c.) If you run xp_msver, what output do you get?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

Cannot create an ODBC connection to SQl 2000.

Hi all,

I have SQL 2000 enterprise edition(no service pack) installed on a Windows Server 2003 machine. I can remote access into the server and run SQL but I cannot create an ODBC connection to this from my desktop. From some research it looks like installing service packs might correct this but here is the error:

--connection failed

--sqlstate '01000'

--sql server error 10061

--connection failed

--sqlstate 08001

--sql server error 17

--SQL server does not exist or access denied

Any help would be appreciated.

Verify whether the SQL Server is listening on a TCP port. If it's a default instance it is by default 1433, so you can use

netstat -an | findstr 1433

If not but the TCP protocol is turned on for the server (and set to port 1433) then upgrading to the latest service pack will most likely solve your problem.

|||

It'd better for you to upgrade SQL Server 2000 to latest service pack 4 from here:

http://support.microsoft.com/kb/290211#EOADAA

then make sure following things before you make connection:

1) SQL Service is running

2) If make remote connection, make sure named pipe or TCP was enabled and try Peter's suggestion if you want to connect through tcp.

HTH.

Cannot create ADO connection to DB anymore...

I rebuilt my machine a few weeks back - re-installed the developer version...

The app in question can see all it's tables in the SQL back end via ODBC and
everything looks normal via Enterprise Manager, but I can no longer create
an ADO Connection.

Source code is unchanged, what's changed is the PC rebuild and consequent
re-installatin of SQL Server developer version.

I suspect it's something to do with the provider (at least that's the only thing
I can see in the .Connect string that's not verifiably correct...)

The error looks like this after I trap and format it:

--------------------
12/30/03 21:34:30v0.71 Userid: UPQC on SAG
Proc: basADO: ADO_ConnectionCreate
-2147467259: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does
not exist or access denied.
Errors encountered when trying to connect:
'''[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

----Connect String:
Provider=SQLOLEDB.1;SERVER=SAG;DATABASE=TRETS;UID= Trets;PWD=trets
--------------------

Can anybody see anything obvious to look for?

I'm thinking I need to know how to verify/validate the presence of provider
"SQLOLEDB.1"... But how?
--
PeteCresswellHi

Maybe it's a SID type problem! Have you tried a trusted connection?

John

"(Pete Cresswell)" <x@.y.z> wrote in message
news:lkd4vv89m3cdb5fnlt4rt661c47sb56jdv@.4ax.com...
> I rebuilt my machine a few weeks back - re-installed the developer
version...
> The app in question can see all it's tables in the SQL back end via ODBC
and
> everything looks normal via Enterprise Manager, but I can no longer create
> an ADO Connection.
> Source code is unchanged, what's changed is the PC rebuild and consequent
> re-installatin of SQL Server developer version.
> I suspect it's something to do with the provider (at least that's the only
thing
> I can see in the .Connect string that's not verifiably correct...)
> The error looks like this after I trap and format it:
> --------------------
> 12/30/03 21:34:30v0.71 Userid: UPQC on SAG
> Proc: basADO: ADO_ConnectionCreate
> -2147467259: [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does
> not exist or access denied.
> Errors encountered when trying to connect:
> '''[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or
> access denied.
> ----Connect String:
> Provider=SQLOLEDB.1;SERVER=SAG;DATABASE=TRETS;UID= Trets;PWD=trets
> --------------------
>
> Can anybody see anything obvious to look for?
> I'm thinking I need to know how to verify/validate the presence of
provider
> "SQLOLEDB.1"... But how?
> --
> PeteCresswell

Thursday, March 8, 2012

Cannot create a report - VS 2005/SQL 2005

I cannot seem to create a Report based on an SQL Server 2005 database. The
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :

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

Exception of type 'System.Runtime.InteropServices.COMException' was thrown. (Microsoft Visual Studio)

Program Location:
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)

Is anyone else having the same problem?
Any help will be appreciated.

Thanks
Sumeetsame error here.... anyone got a work around or a fix?|||

We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert

|||Hi Albert,
I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||

A new version of Refactor! (1.0.30, 12/7/2005) is available which may fix the problem. Give it a try.

-Albert

|||Will do.
However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||

Albert Yen - MS wrote:

We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert

I will check this out as I also have Refactor! installed.

the behavior matches my problem, adding new files is the failure point.

what A pain!

I was thinking it was Team Related ( Version contol etc...) but I shall see.|||

figuerres wrote:

Albert Yen - MS wrote:

We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert

I will check this out as I also have Refactor! installed.

the behavior matches my problem, adding new files is the failure point.

what A pain!

I was thinking it was Team Related ( Version contol etc...) but I shall see.


in my case 2 pc's are now fixed!!! Great!!!!

|||

Updated to the new versions of Refactor and CodeRush - The problem is fixed !
Thanks Albert for pointing the conflict out.
Sumeet

|||Hi
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks

|||

The latest version of Refactor and CodeRush both is 2.0.1

Both can be downloaded from www.devexpress.com

Sumeet

|||I downloaded the software. I tried to install it , but it could not be installed due to error:
"Error 1001: The SavedState Dictionary contains inconsistent

data and might have corrupted."
I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason.
I removed DXcore , and every thing in reporting service in visual studio 2005 become working well !!!..
Is it a bug in DXcore ?
Thanks to you and all contributors in that post.
M. Hassan

Cannot create a report - VS 2005/SQL 2005

I cannot seem to create a Report based on an SQL Server 2005 database. The
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :

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

Exception of type 'System.Runtime.InteropServices.COMException' was thrown. (Microsoft Visual Studio)

Program Location:
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)

Is anyone else having the same problem?
Any help will be appreciated.

Thanks
Sumeet
same error here.... anyone got a work around or a fix?|||

We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert

|||Hi Albert,
I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||

A new version of Refactor! (1.0.30, 12/7/2005) is available which may fix the problem. Give it a try.

-Albert

|||Will do.
However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||

Albert Yen - MS wrote:

We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert

I will check this out as I also have Refactor! installed.

the behavior matches my problem, adding new files is the failure point.

what A pain!

I was thinking it was Team Related ( Version contol etc...) but I shall see.|||

figuerres wrote:

Albert Yen - MS wrote:

We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert

I will check this out as I also have Refactor! installed.

the behavior matches my problem, adding new files is the failure point.

what A pain!

I was thinking it was Team Related ( Version contol etc...) but I shall see.


in my case 2 pc's are now fixed!!! Great!!!!

|||

Updated to the new versions of Refactor and CodeRush - The problem is fixed !
Thanks Albert for pointing the conflict out.
Sumeet

|||Hi
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks

|||

The latest version of Refactor and CodeRush both is 2.0.1

Both can be downloaded from www.devexpress.com

Sumeet

|||I downloaded the software. I tried to install it , but it could not be installed due to error:
"Error 1001: The SavedState Dictionary contains inconsistent data and might have corrupted."
I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason.
I removed DXcore , and every thing in reporting service in visual studio 2005 become working well !!!..
Is it a bug in DXcore ?
Thanks to you and all contributors in that post.
M. Hassan

Cannot create a report - VS 2005/SQL 2005

I cannot seem to create a Report based on an SQL Server 2005 database. The
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :

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

Exception of type 'System.Runtime.InteropServices.COMException' was thrown. (Microsoft Visual Studio)

Program Location:
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)

Is anyone else having the same problem?
Any help will be appreciated.

Thanks
Sumeetsame error here.... anyone got a work around or a fix?|||

We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert

|||Hi Albert,
I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||

A new version of Refactor! (1.0.30, 12/7/2005) is available which may fix the problem. Give it a try.

-Albert

|||Will do.
However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||

Albert Yen - MS wrote:

We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert

I will check this out as I also have Refactor! installed.

the behavior matches my problem, adding new files is the failure point.

what A pain!

I was thinking it was Team Related ( Version contol etc...) but I shall see.|||

figuerres wrote:

Albert Yen - MS wrote:

We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.

-Albert

I will check this out as I also have Refactor! installed.

the behavior matches my problem, adding new files is the failure point.

what A pain!

I was thinking it was Team Related ( Version contol etc...) but I shall see.


in my case 2 pc's are now fixed!!! Great!!!!

|||

Updated to the new versions of Refactor and CodeRush - The problem is fixed !
Thanks Albert for pointing the conflict out.
Sumeet

|||Hi
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks

|||

The latest version of Refactor and CodeRush both is 2.0.1

Both can be downloaded from www.devexpress.com

Sumeet

|||I downloaded the software. I tried to install it , but it could not be installed due to error:
"Error 1001: The SavedState Dictionary contains inconsistent

data and might have corrupted."
I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason.
I removed DXcore , and every thing in reporting service in visual studio 2005 become working well !!!..
Is it a bug in DXcore ?
Thanks to you and all contributors in that post.
M. Hassan

Cannot create a new instance in sqlserver 2005

I have installed sqlserver 2005 and by mistake i have made a default instance. I previously had sqlserver 2000 installed on my machine. Now I want to create a new instance of sqlserver 2005 but dont know how to do it .... Please help me on thisInsert the setup media and simply install another instance. Make sure that you applay the service pack afterwards, because the service pack level is maitained per instance.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Wednesday, March 7, 2012

Cannot connect with SQLCMD - VIA Provider : The specified module could not be found

I have the full version of SQL Server 2005 on my machine under XP. Installed ok and can connect with management studio, but if I try and connect with Analysis Services or even SQLCMD, I get the error below :

HResult 0x7E, Level 16, State 1
VIA Provider: The specified module could not be found.

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

I have networking enabled, I've enabled all the protocols (apart from VIA because it doesn't start if you do that), and I have all the services running.

Any ideas what can be up ?

I have now fixed this issue and thought I'd just list what was wrong :

The VIA message was because in desperation to connect I had enabled some VIA connections - I think client side.

I disabled all connection types for both client and server except shared memory and TCP/IP.

Still didn't work - and gave a message that the server refused connection.

I then looked at the server side TCP options and found the port number, using SQLCMD tcp:servername,portnumber I could now connect !!

Finally changed the client side TCP to use this port number and now can connect with SQLCMD and no options.

My main gripe is why didn't it all work as installed and why did I have to go through all this to get it to connect !!!