Creating Registered Account with access to all database

Question

0.00/5 (No votes)

See more:

I have a SQL Management Studio 2008 on a desktop computer and its connection is on Windows authentication mode. Is it possible to create an account and use a laptop to access the database from my desktop? How do I do this?

Posted 5-Jun-13 17:24pm

Karen Lim Yeung

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

virang_21 · Answer 1 · 2013-06-05T20:15:00

Solution 1

From your SQL Server Management Studio go to Security-> Logins from Object Explorer. Right click on logins and you will be able to create a new user ( Provided you have proper permissions.) . Assign rights to the newly created user to specific database.

Also to connect to the SQL server instance from another machine you need to make sure that it is configured to allow remote connection otherwise you will get the famous Error 26 or Error 40. "Network related or instance specific error occurred"

Posted 5-Jun-13 20:15pm

virang_21

Comments

Karen Lim Yeung 6-Jun-13 22:02pm

IT works in my desktop, I have tried configuring before, but I only tried it on my desktop. Should I configure my laptop as well?

virang_21 6-Jun-13 23:15pm

Are you trying to connect to same database over the network ?

Karen Lim Yeung 7-Jun-13 9:20am

Yes

virang_21 10-Jun-13 19:00pm

Than you don't need to recreate user or configure anything on you notebook again. As long as you have SQL Server Management Studio on your notebook just connect to your desktop instance of SQL server by specifying server name as IP address of your desktop and connecting to it. Make sure you have configured your SQL Server installation on desktop to allow remote connection.

Creating Registered Account with access to all database

1 solution

Solution 1

Add your solution here

Preview 0

Creating Registered Account with access to all database

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us