May 31, 2012 at 5:57 am
Hello everyone,
I have an old computer connected to a home weather station that regularly updates a database(SQL Server 2008R2 Developer Edition). I want to access this instance from other computers on the home network, I have enabled TCP/IP on SQL server and opened port 1433 on my router. Can I connect to this instance from other computers using SQL Server Management Studio express edition? If so what do I need to enter to connect?
The computer IP is 192.168.1.28, server name is WEATHERSTATION and the authentication is set to Windows Authentication.
Many thanks,
Mike
May 31, 2012 at 6:21 am
are you in a domain environment or a workgroup environment?
if workgroup you will need to use SQL authentication to connect, otherwise if your in a domain environment ensure that your windows login(s) have the nessesary access to the server.
May 31, 2012 at 8:36 am
Hi Anthony,
For the SQL Server Authentication, do I enter the username and password of the server machine? e.g. Login: Administrator Password: password
At the moment I'm getting cannot connect / login failed errors.
Thanks
May 31, 2012 at 8:38 am
you will need to set the authentication to mixed mode (sql & windows) restart SQL, then create a SQL account under the security folder in SSMS on the actual server, then you can use that account in SSMS on a remote machine.
May 31, 2012 at 12:04 pm
Thanks a lot Anthony that worked great! now I have the database accessible, can I connect/develop with it using Visual Studio (Ultimate) ?
Many thanks
Mike
June 1, 2012 at 1:44 am
sure as long as you have a connection method that uses the correct credentials you can do what you want to the db.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply