Search results

Sorry yes it's only still in the testing phase.

I added the users to the sysadmin role and have used windows authentication in the odbc connections and it's working. Thanks for the help

I'm unsure as to whether this would solve my problem. I just cannot get sql server authentication to work. Creating an ODBC connection only allows windows authentication, but as my users who will use this connection are not administrators, they cannot connect this way. I need to get sql...

I've done a fresh install and am still having the same issue. Can anyone tell me how I can specify SQL Server administrators (in the same way as you do when you are installing, in the database engine configuration screen) - I can't find the option and don't really want to reinstall again in...

In event viewer I'm getting the following error: Type: Failure Audit, Login failed for user xxx Reason: Attempting to use an NT account name with SQL Server Authentication (CLIENT: <named pipe>). Sounds obvious, but I've tried sa as a username and that doesn't work either.

Hi I'm running SQL server 2008 and am trying to use ODBC connections with SQL Server authentication. I can only get Windows authentication to work however, which is unsuitable for my application. I've used the 'This account' section in the Log On tab of SQL Server Browser and the SQL Server...

The sql instance on 2003 was originally in sql 2000, which I assume is why I can't add Integration Services. I'll either try and add a new server instance or I'll start from scratch with new install.

The only thing that I can see that is different across the two platforms is that in object explorer, the XP (working) instance is SQL Server 10.0.1600, whereas the 2003 instance is SQL Server 8.00.2039. Could this be the cause of the problem?

It's definitely installed - I am connected to it in my object explorer. In the Execute Package Utility it's version 2.0 on both platforms.

Just another slight issue I'm having now. When I add the package as a job in XP on my machine, there are no problems - however, I've since created a package on a Server 2003 machine, and when I try to add a step into the job, the type 'SQL Server Integration Services Package' doesn't appear in...

Darn it! I thought I'd already tried that and it had said that the option wasn't available. Anyway that worked a treat, many thanks! I need to read up a bit on SSIS :( Thanks again

The connection string uses SQL authentication. When I'm in the connection properties in Visual Studio the test connection works fine. In Connection Manager, I've ticked 'save my password' but the field stays blank when I go back in. However it doesn't appear blank in the 'properties' window...

I've created a job and tried to run it that way, but again it's failing on the login to the destination database. The password appears to be there though in VS 2008.

Well first of all I've been trying to simply right click the SSIS in Integration Services in the object explorer and then clicking Ruin Package, which is where it is erroring. Is creating a job the way to do it?

Hi I've recently started using SSIS packages in 2008 as we have had to upgrade from SQL 2000 where I implemented several DTS packages. I have created a simple SSIS package that simply copies one table from one sql server to another. This package runs fine until I save it, then I just cannot...

Hi We have an online form for customers to fill out - this data is then placed into an mdb on the same web server. What I want to do is query this database from our intranet, but to do this I need to create a connection to the remote database, which is where I am hitting trouble. When...

Hi When I filter on a form on our database, I cannot then remove this filter. In order to continue working i have to exit the database completely! Please help!

That helps, thanks. But do you however know of a way to, say, shutdown a computer that is connected? Thanks

Hi all I'm about to start on a new project - automatically compacting and repairing our databases every evening. I am confident that I can do this (just!), my only issue is deleting the lockfile in case any users have forgotten to log off the databases before they have left. Obviously I will...

doh! That's fixed it, thankyou very much!