Opening a database in SQL Server Mgmt Studio Expre

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Opening a database in SQL Server Mgmt Studio Expre

Author

Topic

cseward
Starting Member

24 Posts

Posted - 2011-12-01 : 12:23:47

I hope I can describe this properly. At my workplace, we have a workgroup, not a network. Out data is on a server in Chicago which I can log onto with Remote Desktop Connection. Our contractors enter their time via the internet to the server. I do reporting with the data. However, I can't connect to the database directly - I have to copy data down to my PC, import it to Access and report off the Access DB. I use Crystal Reports as my main reporting tool. I have SQL server Mgmt Studio 2008 on my local machine which has been useless to me since there is no database to connect to. So, I have 2 questions.

1. Does anyone know if there is a way to take a backup of the DB (which I can easily copy to my local machine) and somehow open it in the SQL Mgmt studio on my local machine ??

2. Also, is there a way for me to access the remote server from my local machine ?

I hope my questions make sense.

Thanks in advance

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-01 : 12:28:30

1. you take backup from the actual server which will be a .bak file. then copy file to your local machine and then connect to local server using sql management studio and restore db from .bak file.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

cseward
Starting Member

24 Posts

Posted - 2011-12-01 : 12:32:33

thank you for the reply. However, I'm still stuck. How do I connect to a local server, if there is no local server ? I'm not sure I follow. We have a share drive - that drive resides on a computer on the workgroup - would that be a local server ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-01 : 12:36:48

quote:
Originally posted by cseward

thank you for the reply. However, I'm still stuck. How do I connect to a local server, if there is no local server ? I'm not sure I follow. We have a share drive - that drive resides on a computer on the workgroup - would that be a local server ?

local server exists if you've installed sql server in your local machine. to check that run services.msc from start->run and then check if it has sql server service listed

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

cseward
Starting Member

24 Posts

Posted - 2011-12-01 : 12:41:53

I was able to restore the DB on my local machine. Hooray - thank you for your quick reply !!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-01 : 12:44:59

wc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

cseward
Starting Member

24 Posts

Posted - 2011-12-01 : 12:55:24

Now I have to figure out how to connect to this local backup with Crystal reports. In past jobs, I just set up an ODBC connection to the server, but so far I can't find the DB. Please let me know if anyone has a suggestion for this part.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-01 : 12:57:04

quote:
Originally posted by cseward

Now I have to figure out how to connect to this local backup with Crystal reports. In past jobs, I just set up an ODBC connection to the server, but so far I can't find the DB. Please let me know if anyone has a suggestion for this part.

you can use the same way
add a odbc connection to connect to db restored on local server and then you can use it connect from crystal report to local server

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sandy123
Starting Member

14 Posts

Posted - 2011-12-01 : 12:57:30

2. Also, is there a way for me to access the remote server from my local machine ?

if you able connect the remote server.
local machine -Open SSMS -click Connect - give remote machine name or IP address-
Authentication - select Windows are SQL - give credential.

sandy

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-01 : 13:02:18

quote:
Originally posted by sandy123

2. Also, is there a way for me to access the remote server from my local machine ?

if you able connect the remote server.
local machine -Open SSMS -click Connect - give remote machine name or IP address-
Authentication - select Windows are SQL - give credential.

sandy

Not sure that will work in OPs case as local machine is in a work group so unless remote sql server is open to internet I doubt ability of connecting like above

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources