![]() | |
![]() |
| | Thread Tools | Display Modes |
#31
| |||
| |||
|
|
SSMS is a client tool that can be installed anywhere (client or server). Regardless of where it is installed you can (given the proper permissions of course) connect to any SQL Server instance installed either locally on that machine or remotely on another. SSMS itself can not run the query it just submits it to the server. So I am a little confused as to your question. Do you already have a SQL Server instance with a database that you want to connect to or are you asking if you can install a fresh instance? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Glenn" <nospam (AT) yahoo (DOT) com> wrote in message news:eOAzFWN6IHA.3512 (AT) TK2MSFTNGP02 (DOT) phx.gbl... not sure if this is the right group for this question...please redirect me if not Is thee a way the SQL Server Management Studio on my local computer so that I can run queries, etc.? I tried running setup from Disk 2 and thought it would do what I was trying to do, but nothing showed up in all programs after running the install. |
#32
| |||
| |||
|
|
I already have a SQL server instance install on a server. I'm trying to find out how to connect to it from my desktop. I can't seem to find the install program. "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote in message news:eXHqVeN6IHA.3756 (AT) TK2MSFTNGP06 (DOT) phx.gbl... SSMS is a client tool that can be installed anywhere (client or server). Regardless of where it is installed you can (given the proper permissions of course) connect to any SQL Server instance installed either locally on that machine or remotely on another. SSMS itself can not run the query it just submits it to the server. So I am a little confused as to your question. Do you already have a SQL Server instance with a database that you want to connect to or are you asking if you can install a fresh instance? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Glenn" <nospam (AT) yahoo (DOT) com> wrote in message news:eOAzFWN6IHA.3512 (AT) TK2MSFTNGP02 (DOT) phx.gbl... not sure if this is the right group for this question...please redirect me if not Is thee a way the SQL Server Management Studio on my local computer so that I can run queries, etc.? I tried running setup from Disk 2 and thought it would do what I was trying to do, but nothing showed up in all programs after running the install. |
#33
| |||
| |||
|
|
I already have a SQL server instance install on a server. I'm trying to find out how to connect to it from my desktop. I can't seem to find the install program. "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote in message news:eXHqVeN6IHA.3756 (AT) TK2MSFTNGP06 (DOT) phx.gbl... SSMS is a client tool that can be installed anywhere (client or server). Regardless of where it is installed you can (given the proper permissions of course) connect to any SQL Server instance installed either locally on that machine or remotely on another. SSMS itself can not run the query it just submits it to the server. So I am a little confused as to your question. Do you already have a SQL Server instance with a database that you want to connect to or are you asking if you can install a fresh instance? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Glenn" <nospam (AT) yahoo (DOT) com> wrote in message news:eOAzFWN6IHA.3512 (AT) TK2MSFTNGP02 (DOT) phx.gbl... not sure if this is the right group for this question...please redirect me if not Is thee a way the SQL Server Management Studio on my local computer so that I can run queries, etc.? I tried running setup from Disk 2 and thought it would do what I was trying to do, but nothing showed up in all programs after running the install. |
#34
| |||
| |||
|
|
I already have a SQL server instance install on a server. I'm trying to find out how to connect to it from my desktop. I can't seem to find the install program. "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote in message news:eXHqVeN6IHA.3756 (AT) TK2MSFTNGP06 (DOT) phx.gbl... SSMS is a client tool that can be installed anywhere (client or server). Regardless of where it is installed you can (given the proper permissions of course) connect to any SQL Server instance installed either locally on that machine or remotely on another. SSMS itself can not run the query it just submits it to the server. So I am a little confused as to your question. Do you already have a SQL Server instance with a database that you want to connect to or are you asking if you can install a fresh instance? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Glenn" <nospam (AT) yahoo (DOT) com> wrote in message news:eOAzFWN6IHA.3512 (AT) TK2MSFTNGP02 (DOT) phx.gbl... not sure if this is the right group for this question...please redirect me if not Is thee a way the SQL Server Management Studio on my local computer so that I can run queries, etc.? I tried running setup from Disk 2 and thought it would do what I was trying to do, but nothing showed up in all programs after running the install. |
#35
| |||
| |||
|
|
I already have a SQL server instance install on a server. I'm trying to find out how to connect to it from my desktop. I can't seem to find the install program. "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote in message news:eXHqVeN6IHA.3756 (AT) TK2MSFTNGP06 (DOT) phx.gbl... SSMS is a client tool that can be installed anywhere (client or server). Regardless of where it is installed you can (given the proper permissions of course) connect to any SQL Server instance installed either locally on that machine or remotely on another. SSMS itself can not run the query it just submits it to the server. So I am a little confused as to your question. Do you already have a SQL Server instance with a database that you want to connect to or are you asking if you can install a fresh instance? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Glenn" <nospam (AT) yahoo (DOT) com> wrote in message news:eOAzFWN6IHA.3512 (AT) TK2MSFTNGP02 (DOT) phx.gbl... not sure if this is the right group for this question...please redirect me if not Is thee a way the SQL Server Management Studio on my local computer so that I can run queries, etc.? I tried running setup from Disk 2 and thought it would do what I was trying to do, but nothing showed up in all programs after running the install. |
#36
| |||
| |||
|
|
I already have a SQL server instance install on a server. I'm trying to find out how to connect to it from my desktop. I can't seem to find the install program. "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote in message news:eXHqVeN6IHA.3756 (AT) TK2MSFTNGP06 (DOT) phx.gbl... SSMS is a client tool that can be installed anywhere (client or server). Regardless of where it is installed you can (given the proper permissions of course) connect to any SQL Server instance installed either locally on that machine or remotely on another. SSMS itself can not run the query it just submits it to the server. So I am a little confused as to your question. Do you already have a SQL Server instance with a database that you want to connect to or are you asking if you can install a fresh instance? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Glenn" <nospam (AT) yahoo (DOT) com> wrote in message news:eOAzFWN6IHA.3512 (AT) TK2MSFTNGP02 (DOT) phx.gbl... not sure if this is the right group for this question...please redirect me if not Is thee a way the SQL Server Management Studio on my local computer so that I can run queries, etc.? I tried running setup from Disk 2 and thought it would do what I was trying to do, but nothing showed up in all programs after running the install. |
#37
| |||
| |||
|
|
I already have a SQL server instance install on a server. I'm trying to find out how to connect to it from my desktop. I can't seem to find the install program. "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote in message news:eXHqVeN6IHA.3756 (AT) TK2MSFTNGP06 (DOT) phx.gbl... SSMS is a client tool that can be installed anywhere (client or server). Regardless of where it is installed you can (given the proper permissions of course) connect to any SQL Server instance installed either locally on that machine or remotely on another. SSMS itself can not run the query it just submits it to the server. So I am a little confused as to your question. Do you already have a SQL Server instance with a database that you want to connect to or are you asking if you can install a fresh instance? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Glenn" <nospam (AT) yahoo (DOT) com> wrote in message news:eOAzFWN6IHA.3512 (AT) TK2MSFTNGP02 (DOT) phx.gbl... not sure if this is the right group for this question...please redirect me if not Is thee a way the SQL Server Management Studio on my local computer so that I can run queries, etc.? I tried running setup from Disk 2 and thought it would do what I was trying to do, but nothing showed up in all programs after running the install. |
#38
| |||
| |||
|
|
I already have a SQL server instance install on a server. I'm trying to find out how to connect to it from my desktop. I can't seem to find the install program. "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote in message news:eXHqVeN6IHA.3756 (AT) TK2MSFTNGP06 (DOT) phx.gbl... SSMS is a client tool that can be installed anywhere (client or server). Regardless of where it is installed you can (given the proper permissions of course) connect to any SQL Server instance installed either locally on that machine or remotely on another. SSMS itself can not run the query it just submits it to the server. So I am a little confused as to your question. Do you already have a SQL Server instance with a database that you want to connect to or are you asking if you can install a fresh instance? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Glenn" <nospam (AT) yahoo (DOT) com> wrote in message news:eOAzFWN6IHA.3512 (AT) TK2MSFTNGP02 (DOT) phx.gbl... not sure if this is the right group for this question...please redirect me if not Is thee a way the SQL Server Management Studio on my local computer so that I can run queries, etc.? I tried running setup from Disk 2 and thought it would do what I was trying to do, but nothing showed up in all programs after running the install. |
#39
| |||
| |||
|
|
I already have a SQL server instance install on a server. I'm trying to find out how to connect to it from my desktop. I can't seem to find the install program. "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote in message news:eXHqVeN6IHA.3756 (AT) TK2MSFTNGP06 (DOT) phx.gbl... SSMS is a client tool that can be installed anywhere (client or server). Regardless of where it is installed you can (given the proper permissions of course) connect to any SQL Server instance installed either locally on that machine or remotely on another. SSMS itself can not run the query it just submits it to the server. So I am a little confused as to your question. Do you already have a SQL Server instance with a database that you want to connect to or are you asking if you can install a fresh instance? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Glenn" <nospam (AT) yahoo (DOT) com> wrote in message news:eOAzFWN6IHA.3512 (AT) TK2MSFTNGP02 (DOT) phx.gbl... not sure if this is the right group for this question...please redirect me if not Is thee a way the SQL Server Management Studio on my local computer so that I can run queries, etc.? I tried running setup from Disk 2 and thought it would do what I was trying to do, but nothing showed up in all programs after running the install. |
#40
| |||
| |||
|
|
I already have a SQL server instance install on a server. I'm trying to find out how to connect to it from my desktop. I can't seem to find the install program. "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote in message news:eXHqVeN6IHA.3756 (AT) TK2MSFTNGP06 (DOT) phx.gbl... SSMS is a client tool that can be installed anywhere (client or server). Regardless of where it is installed you can (given the proper permissions of course) connect to any SQL Server instance installed either locally on that machine or remotely on another. SSMS itself can not run the query it just submits it to the server. So I am a little confused as to your question. Do you already have a SQL Server instance with a database that you want to connect to or are you asking if you can install a fresh instance? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Glenn" <nospam (AT) yahoo (DOT) com> wrote in message news:eOAzFWN6IHA.3512 (AT) TK2MSFTNGP02 (DOT) phx.gbl... not sure if this is the right group for this question...please redirect me if not Is thee a way the SQL Server Management Studio on my local computer so that I can run queries, etc.? I tried running setup from Disk 2 and thought it would do what I was trying to do, but nothing showed up in all programs after running the install. |
![]() |
| Thread Tools | |
| Display Modes | |
| |