I am using SQL Server tools (Enterprise Manager and Query Analyser) that are
installed on my local PC to work on databases that are on another server. The
other server is not on this network -- I access it via the internet. At the
moment I acess it using it's IP address and a SQL Server username and
password.
>From what I have read, it seems that Windows Authentication is more secure
than SQL Server Authentication. How can I use these local tools to access
this remote SQL Server, using Windows Authentication ?
RE: HELP! Cannot connect to SQL Server ... Read another post in this forum that said to change the SQL Server... Registration" to use "SQL Server authentication."... bring up the databases under. ... > "server" that has two of my financial databases under it. ... (microsoft.public.sqlserver.setup)
Re: How can I get the Management Studio ... According to this Q & A, I'll need another SQL Server license because I'll be using a SQL Server Tool on it? ... "any device that has SQL Server tools or technologies installed must have a valid license" ... It would basically mean we can buy one per processor SQL Server and install SSMS on all the machines in the world? ... (microsoft.public.sqlserver.tools)
Re: How can I get the Management Studio ... a SQL Server server; however, a SQL Server Tool is going to be used on it. ... According to this Q & A, I'll need another SQL Server license because I'll be using a SQL Server Tool on it? ... "any device that has SQL Server tools or technologies installed must have a valid license" ... It would basically mean we can buy one per processor SQL Server and install SSMS on all the machines in the world? ... (microsoft.public.sqlserver.tools)
Re: How can I get the Management Studio ... I'd say that the key word here is "separate".... There's no "SQL Server tools" license you can buy. ... (microsoft.public.sqlserver.tools)
Re: How can I get the Management Studio ... I know there is no such a license SQL Server Tools license =) ... As it says "any device that has SQL Server tools or technologies installed must have a valid license" in the Q & A, I end up with a question mark: "I have a SQL Server server which has SQL Server database engine and tools installed on it and have a license for that particular SQL Server server, however I want to use the SQL Server tool SSMS on another server in my environment, according to that Q & A, I'm using a SQL Server tool on another device other than that licensed SQL Server server and as it says 'you need a valid license for SQL Server tools' do I need any other SQL Server license for the other unlicensed server which I'd like to install only SSMS?"... ... Of course, on a desktop you can install those tools, which include Management Studio, without installing the SQL Server engine. ... (microsoft.public.sqlserver.tools)
