MS SQL Server Exprs - Connection via IP adress ?

[hendelsesloysa]

I've got Microsoft SQL Server EXPRESS and have a .mdf file (SQL file).

My question is; (1) how do I connect this .mdf file to the Express server so that I can connect to the server externaly elsewhere in the network from an IP adress?

Now I only can connect to the file if it's placed locally on my harddrive, but this database will be used from different computers in the network, and I want the server to handle all these connection.

(2) Also, the SQL server says the login/password is incorrect, how do I set the login/passord on the Express server ?

[Asgorath]

1) See http://www.connectionstrings.com/ on how to create the apropriate connection string.
2) This example changes the password for the login Victoria to ok.
EXEC sp_password NULL, 'ok', 'Victoria'
Jorge

[hendelsesloysa]

Thanks for the reply for the second question.

But .. do anyone know why the application crashes when runned from a networked disk?

[Asgorath]

what error does it give before crashing?

[hendelsesloysa]

what error does it give before crashing?

No error at all, it crashes when using the .open statement without any error, only the,

"YourApplication has encountered a problem and needs to close. We are sorry for the inconvenience."

"EventType : clr20r3 P1 : yourapplication.exe P2 : 1.0.0.0 P3 : 45045147 P4 : imei checker P5 : 1.0.0.0 P6 : 45045147 P7 : 11 P8 : c6 P9 : system.invalidoperationexception "

[hendelsesloysa]

1) See http://www.connectionstrings.com/ on how to create the apropriate connection string.
2) This example changes the password for the login Victoria to ok.
EXEC sp_password NULL, 'ok', 'Victoria'
Jorge

This change the password, but how to open up a new login account.

I want to set up a new account named ACCOUNT1 with password VICTORIA.

[Asgorath]

This example creates a SQL Server login for the user Albert, with a password of food and a default database of corporate.
EXEC sp_addlogin 'Albert', 'food', 'corporate'

Jorge