Search results for query: *

We migrated to from SQL Server 2000 to SQL Server 2005. 2005 has been configured in mixed mode authentication. When I try to create/save a function from my client (local) machine I get the following error: "Login failed for User xxx". I should mention that within the function, there is...

Hi, We migrated to SQl server 2005 and it is in mixed mode. When I try to create a function from my client (local) machine then it gives me an error "Login failed for User JOHN", but when I remotely login to server and try to create a function, it works fine. Can someone please help me with...

It works now. The issue was the stp that was referenced was not sql 2005 compatible after we fixed the stp, it works fine. Thanks!

Tried these, still doesn't work. One of the developers in my group think that this has global security setting or something similar. But I do not agree with this as we are able to connect to Db thru SSMS, the crystal reports call stps in the Db works fine. Not sure what else is something. Any...

Yes, I tried that i am able to connect to both the DB's Prod db and Dev db with the same userid and passwd. We have reports in Crystal 10 and when I open the raw report with the same user id it works fine. Observed one more thing we call the crystal 10 reports in a Vb application and say i...

Yes they both are on the same server.

I am sure I am posting this to the wrong section of this forum. My question is related to SQL Server 2005 and Classic ASP. I can't seem to connect to our prod db using the below code. <% set cn=server.createobject("ADODB.Connection") cn.provider = "sqloledb" provstr =...

Hi, I have an application written in VB 6.0. It used to point to server A, now since we moved to new server, the app needs to point to Server B. The server name (for ex old server A) is hardcoded, so i changed it to server B (new server name) and created .exe again. It still points to the old...

Yes. Here's how my sql jobs are: My jobs call .exe but the .exe inturn calls DTS package. The DTS package sits in a folder (for ex: h:\DTSPAckages\ImportTestfile.dts). Since we are migrating from SQL server 2000 to SQL server 2005 as we do not have enough time to rewrite the DTS packages, we...

The user that we use to run these jobs has sysa permissions. --Thanks

It's not a cube, i have sql server agent job. We just switched from sql 2000 to sql 2005. It used to work in sql 2000. But I recreated this job in sql 2005, it fails.

Can someone help me with this please. I have 2005 sql server jobs that are scheduled to run automaticallybut are failing to run. The jobs call .exe (.exe is in VB 6.0). When i look at the history of the job it says that the "Executed as user: The step did not generate any output. Process Exit...

I have a project in VB 6.0. We are moving to a new server (serverB) and have change in the servername.At the time of loading the VB application on new server it gives an error: Error message: "CRVIEWER9.dll could not be loaded -- Continue loading Project"? if I click on yes then it gives me one...

That's true, but I have more than 50 DTS and do not have much time left to rewrite them. I have moved all of them under legacy and installed SQl 2000 DTS designer components i get the following error: ""the DTS host failed to load or save the package properly" ANy help please.

After installing SQL 2000 DTS designer components was anyone able to run the SQl 2000 DTS under legacy in sql 2005 management studio. I get error. Thanks in advance!

After I installed the SQL server 2000 DTS designer components on new server where i have sql 2005 and where i have all the DTS under legacy, when I try to open DTS it gives me error saying that "the DTS host failed to load or save the package properly" ANy help please.

My folder sits at Z:/Apps/DTS. All DTS packages are saved in the DTS folder, how can I make the service account for MSSQLSERVER service to have write permissions on this folder. Thanks!

Can someone help me with this ---How can I make the service account for MS SQL server service to have write permissions on a folder. Thanks!

Stored procedures were checked but the execute permissions were missed. Perfect, it works now. Thanks a bunch!

But the problem is I cant see the stored procedure in the pane where I create my new ODBC eventhough it really exists in the database, i checked it thru Management studio. Thanks!