Hi there.

Actually the problem here was invalid data. The error report told me this but not where the data was located. Therefore, I imported my data using selects until...

Hi Yelena,

Sorry for the late reply - I have seen been continuing tests on a copy of the data. Howevr, I took the two steps above and everything is order...

Ok thanks for that. I think I was a getting a little confused as

I wasn't alway using the system adminstrator to administrate users etc. This I think was the...

Hi Yelena,

I right-click on the datbase of my choice->tasks-import data. The import/export wizard appears. I select Microsoft Access as a data source and SQL Auth. as authenification procedure (plus username/password)....

OK, I solved this problem. One has to click the user, navigate to security elements and select tables as an an object type. Then choose the table followed by the...

Thanks Derek,

Actually I just imported it using the object explorer, right-clicking on the database-> tasks and then import data.

Thanks for your help

Oh I just found the solution, I need the sql client installed on the client. Through the sql client I can make the connection.

Oh I love it when things are nice and simple.

OK, I executed the query and got the result:

"Command(s) completed successfully."

I am able to...

I just looked at your previos message:

go to 2005 server management studio, right click on the server,choose properties and then click on security - ensure it is set to windows...

Well I just applied a couple more users with sql authentication and that seems to work locally as before. Actually when I acreate the Login user - I can only...

via LAN

I have just noticed another point. I can register locally but only by using windows authentifcation. When I am in the connect to server dialog from Microsoft SQL Server...

Oh and I also attach the port number 1433 to my ip adress.

I can access the database locally now (in the Express version). However, this is not possible remotely. I am actually trying to connect to it through a java app ...

Sorry, but the sql ports are not being blocked by a firewall.

Thank anyway

I created the new user over Login->New Login. There's is then a dialog box where I set the username, password, authentification mode etc. I have also included this user in...