Connect To Remote Instance Of SSIS From SSMS Using SQL Login?

May 25, 2007

I have installed a SQL Server 2005 Standard Edition instance with SSIS on Window Server 2003 x64. From my PC, I am able to connect to the Integration Services on the server using Windows Authentication but not with a local SQL login - and the option to change authentication methods is greyed out.



Is it possible to remotely connect to SSIS using a SQL login rather than a Windows login? If so, any ideas or references for configuring it as such?



Thanks.



- Lance

View 1 Replies


ADVERTISEMENT

Cannot Connect To Remote SSRS Instance With SSMS

Jun 13, 2006

I recent installed a named instance of SSRS 2005 on a remote server. The server has a side by side install of SSRS 2000 and SSRS 2005, with the SSRS 2005 being a named instance. The server also has SSL and MS Sharepoint Portal Server installed.

When I try and connect to the SSRS 2005 instance with my client install of Mangement Studio, I get the error message:

"The underlying connection was closed: Could not establish a trust relationship for the SSL/TLS secure channel. (System.Web.Services)

Additional Information: The remote certificate is invalid according to the validation procedure. (System)."

Obviously, this is a SLL issue, but, not being a security guru, I have no clue on how to fix this. I do know the certificate is valid, not expired and properly working. Both installs of SSRS are set up using the SSL certificate. Also, I am not connecting to SSIS with Management Studio, as I heard there is a bug connecting to both SSRS and SSIS at the same time.

Anyone have any ideas?

Thanks!!

Jeff

View 6 Replies View Related

Integration Services :: SSIS - Can't Connect Using SSMS Remote (locally OK)

May 18, 2015

Error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) (Microsoft.SqlServer.DTSRuntimeWrap)
 
Here are the steps I followed:

To configure rights for remote users on Windows Server 2003 or Windows XP

View 10 Replies View Related

SQL Server Admin 2014 :: Cannot Connect To Named Instance (2nd Instance) From Local SSMS

Jul 22, 2015

I've two instances(Default, Named[dynamicsFINANCE]) running on SQL server 2014. However, when I try to connect to named instance say (dynamicsFINANCE) using SQL authentication from local SSMS, I get below error message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

I assigned a static port number to the named instance [dynamicsFINANCE] 1450. I also setup the firewall rule to allow access to Port 1450.

View 5 Replies View Related

Using SSIS Package To Connect A Remote Sql Server--login Failed.

Feb 13, 2006

Hi,

i created a SSIS package to import data to a remote sql server, using the following connection string:

"Data Source=My-SQL;User ID=PortalUser;Password=Password;Initial Catalog=TestOMIWarehouse;Provider=SQLNCLI.1;Auto Translate=True;";

and got an error "Login failed".

When i give PortalUser a sysadmin server role, it works. But i don't want to give PortalUser a sysadmin role. Any suggestions? Is sysadmin role required to access a remote server using Sql server authentication?

thanks! Any help would be appreciated.

alea



View 4 Replies View Related

DB Engine :: Cannot Connect To Named Instance From Local SSMS

Jul 22, 2015

I've two instances(Default, Named[dynamicsFINANCE]) running on SQL server 2014. However, when I try to connect to named instance say (dynamics FINANCE) using SQL authentication from local SSMS, I get below error message.A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)I assigned a static port number to the named instance [dynamicsFINANCE] 1450. I also setup the firewall rule to allow access to Port 1450.

View 4 Replies View Related

SQL Authentication To Connect To SSIS Through SSMS

Oct 23, 2007

hi guys,
do you know if we can use sql authentication to connect to SSIS through SSMS. right now it's only windows authentication, and SQL authentication is grayed out.

Not sure if this question has already been answered because it sounds like easy question.

View 1 Replies View Related

DB Engine :: Cannot Connect To Remote Named Instance Of Server

May 8, 2013

We have 3x instances of SQL Server 2012 installed on a single remote server - there's the default MSSQLSERVER instance, then INSTANCE01 and INSTANCE02. I can remotely connect to the default MSSQLSERVER instance through SSMS, but I cannot connect to either of the additional named instances (INSTANCE01 or INSTANCE02). 

For example, if I try to connect to "sql.domain.com", I can successfully access the default instance on the remote server. If I try to connect to "sql.domain.comINSTANCE01", I get an error stating

"A network-related or instance-specific error occurred while establishing a connection to SQL Server".

However - if I try to connect to "sql.domain.comINSTANCE01, 49301" (where 49301 is the TCP Port for the TCP/IP Protocol for this SQL Server instance), I am able to successfully connect.

This leads me to think that there's a communication issue with the SQL Server Browser service running on the remote SQL Server and my workstation. 

The following items have been verified:

SQL Server Browser is running on the remote SQL ServerWindows Firewall has been disabled on the SQL ServerTCP Ports 1433, 1434, 1954, and 49301 have been opened up on the remote destination's firewallUDP Port 1434 has been opened up on the remote destination's firewall.

View 10 Replies View Related

Login Failed When Trying To Connect To Local Instance Of SQL 2005 DB

Jan 2, 2008

I installed SQL 2005 Developer addition on my Vista laptop. When I open Management Studio to connect to the local instance of the DB, I get the error below. Why can't I access? Is there something with Vista that is prohibiting?

Thanks


TITLE: Microsoft SQL Server Management Studio
------------------------------

Login failed for user 'xxxx'. (Microsoft SQL Server, Error: 18456)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

View 1 Replies View Related

Cannot Connect To A Remote SSIS Server

Jan 25, 2007

I originally posted this issue on the SSIS forum and it was suggested I cross post here. I'm trying to connect to the MSDB database on a remote SSIS server using the integration services connection listed in the drop down box on SQL Server 2005 Management Studio. Every connection attempt ends with an 'Access Is Denied' error message. I have full db_dtsadmin rights on the remote server. We followed the MSDN whitepaper on connecting to a remote SSIS server (the section on eliminating the Access Is Denied error - configuring rights for remote users). Nothing works, I always get the generic access denied error message. Are there other permissions that need to be assigned in conjunction with db_dtsadmin to get this to work? I wonder if there is something simple we're overlooking.



Thanks.

View 4 Replies View Related

Permissions Used To Connect To SSIS On Remote Machine

Jun 27, 2006

We are trying to take advantage of the new Security Context for SSIS but users are unable to connect remotely to the SSIS Service unless they have been added to the Administrators Users Group on the server. I have tried adding them to Guests, Power Users, Remote Desktop Users, Users and SQLServer2005DTSUser$machine but the user is unable to connect.

The message received when the user is unable to connect is:

Cannot connect to 192.x.x.x
Additional Information
-> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
-> Connect to SSIS Service on machine "192.x.x.x" failed:
Access is denied

What is the list of permissions and privileges that a user that does not belong to the server's Administrator group and have sysadmin server role, must have to allow them to create and run a package through SSIS.

View 6 Replies View Related

SSIS - Unable To Connect To The Remote Server

Mar 14, 2007

Hi,

I€™m using a Script Component in SSIS to call a Web Service. The web service is wrapped, using the wsdl tool. The package works, on my local enviroment. Script component calls the web service and returns the data. I€™ll move the web service to another server, web service as Anonymous access is enable. Deployed the Package on a SQL server. But, when excuting the package I get the below error. I can view and invoke the web method and see data even. SSIS is running under a NT AUTHORITYNetworkService account. I know that the problem is permission, but how would I resolve the issue.

Error:
OnInformation,SERVER,DOMAINSqlAdmin,MISPackage,{190832FB-4FF1-4ECD-BF53-4A49864089B4},{D7BF27CD-BDF1-418A-ABFE-BA0A24B921FB},3/14/2007 10:59:11 AM,3/14/2007 10:59:11 AM,0,0x,System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at ScriptComponent_6386cd9eab6a49e7b1a90f69dcc24beb.Service.GetMISAccounts()
at ScriptComponent_6386cd9eab6a49e7b1a90f69dcc24beb.ScriptMain.CreateNewOutputRows()

Any Help will be appreciated

View 1 Replies View Related

Integration Services :: Cannot Remote Connect To 2012 / 2014 SSIS Server

Sep 21, 2015

The following error occurred when trying to connect to 2012/2014 SSIS Server using SSMS remotely. Local connection works fine.Using the info from below link does not resolve the problem.  Permissions are granted through DCOM. If this cannot be resolved, packages will have to stored on filesystem instead.
URL....Connecting to the Integration Services service on the computer "" failed with the following error: "Class not registered".

This error can occur when you try to connect to a SQL Server 2005 Integration Services service from the current version of the SQL Server tools. Instead, add folders to the service configuration file to let the local Integration Services service manage packages on the SQL Server 2005 instance.

View 6 Replies View Related

SQL 2012 :: Clustered SSAS Unable To Connect To Named Instance (instance Not Found On Server)

Mar 20, 2014

I have a 3 node cluster on which I have installed SSAS as it's own insntance. I have created this as a named instance and can connect to it by serverinstance if I'm on the server itself. However from my desktop I get the error saying instance was not found on server name.

I have defined an alternate port and setup firewall rules and can connect via server:port but not serverinstance. Prior to making this change SSAS was running on default port of 2383 and I could connect just by servername.

I have read many articles for previous versions saying that clustered SSAS will always use 2383 and that you must connect just using servername. However and this is were it gets strange. I have a 2 node UAT cluster with SSAS setup exactly the same way I've described above and I can connect from my desktop as serverinstance.

Should I be able to connect as serverinstances for a named clustered instance in 2012 ?

View 4 Replies View Related

DB Engine :: SSMS Connects To Different Instance With Same Hostname - If Ports Are Same

Jun 9, 2015

We have a 2 servers  with 2 default instances, 

Environment- SQL server 2012 SP2 | Windows Server 2008 R2

1server:
hostname-serverA , Instance-serverA and port-2040 Ip-192.164.1.1

2server:
hostname-serverB , Instance-serverB and port-2040 Ip-192.164.1.2

If i do a SSMS connection-the possible connections strings which can be used to connect to Instance "serverB" should be,

a.serverBserverB
b.serverB,2040
c.192.164.1.2,2040

Note: but even the connection string "serverBserverA,2040" also connects to Instance "serverB", when i try to connect from SSMS, In SSMS it shows the wrong instance name like, "serverBserverB", but it actually connects to  Instance "serverA"

i.what is the reason behind this?
ii.Is there any way to avoid this connection, by performing server property changes, if any ?

View 5 Replies View Related

SSMS Won't Connect

Jul 7, 2007

Just installed SQL Server 2005 Standard. When I attempt to connect using SSMS it just sits. No error comes up. The log seems to indicate everythings OK. SQLServer and SQLBrowser services are started. Here's the log:



2007-07-07 09:41:23.07 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2007-07-07 09:41:23.07 Server (c) 2005 Microsoft Corporation.
2007-07-07 09:41:23.07 Server All rights reserved.
2007-07-07 09:41:23.07 Server Server process ID is 2412.
2007-07-07 09:41:23.07 Server Authentication mode is WINDOWS-ONLY.
2007-07-07 09:41:23.07 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-07-07 09:41:23.07 Server This instance of SQL Server last reported using a process ID of 1348 at 7/7/2007 9:35:40 AM (local) 7/7/2007 2:35:40 PM (UTC). This is an informational message only; no user action is required.
2007-07-07 09:41:23.07 Server Registry startup parameters:
2007-07-07 09:41:23.07 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2007-07-07 09:41:23.07 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-07-07 09:41:23.07 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2007-07-07 09:41:23.11 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-07-07 09:41:23.11 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-07-07 09:41:23.34 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-07-07 09:41:23.36 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-07-07 09:41:23.89 Server The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.
2007-07-07 09:41:23.89 Server Database mirroring has been enabled on this instance of SQL Server.
2007-07-07 09:41:23.90 spid5s Starting up database 'master'.
2007-07-07 09:41:24.20 spid5s SQL Trace ID 1 was started by login "sa".
2007-07-07 09:41:24.28 spid5s Starting up database 'mssqlsystemresource'.
2007-07-07 09:41:24.31 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-07-07 09:41:25.65 Server A self-generated certificate was successfully loaded for encryption.
2007-07-07 09:41:25.67 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalMSSQLSERVER ].
2007-07-07 09:41:25.67 Server Server local connection provider is ready to accept connection on [ \.pipesqlquery ].
2007-07-07 09:41:25.67 spid9s Starting up database 'model'.
2007-07-07 09:41:25.67 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2007-07-07 09:41:25.67 Server Dedicated admin connection support was established for listening locally on port 1434.
2007-07-07 09:41:25.68 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2007-07-07 09:41:25.68 spid5s Server name is 'LAPTOP'. This is an informational message only. No user action is required.
2007-07-07 09:41:25.71 spid12s Starting up database 'msdb'.
2007-07-07 09:41:25.71 spid13s Starting up database 'ReportServer'.
2007-07-07 09:41:25.71 spid14s Starting up database 'ReportServerTempDB'.
2007-07-07 09:41:25.71 spid15s Starting up database 'testx'.
2007-07-07 09:41:27.45 spid9s Clearing tempdb database.
2007-07-07 09:41:28.65 spid9s Starting up database 'tempdb'.
2007-07-07 09:41:28.78 spid5s Recovery is complete. This is an informational message only. No user action is required.
2007-07-07 09:41:28.78 spid12s The Service Broker protocol transport is disabled or not configured.
2007-07-07 09:41:28.78 spid12s The Database Mirroring protocol transport is disabled or not configured.
2007-07-07 09:41:29.25 spid12s Service Broker manager has started.
2007-07-07 09:57:23.54 Server CPU time stamp frequency has changed from 117988 to 200203 ticks per millisecond. The new frequency will be used.
2007-07-07 10:09:23.85 Server CPU time stamp frequency has changed from 200203 to 242307 ticks per millisecond. The new frequency will be used.
2007-07-07 10:20:03.20 spid12s Service Broker manager has shut down.
2007-07-07 10:20:04.25 spid5s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
2007-07-07 10:20:04.25 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

View 3 Replies View Related

SQL Tools :: Possible To Get Multi-database Functionality On Same Instance Option Available In SSMS

Sep 27, 2015

Would it be possible to get a multi-database functionality on the same instance option available in SSMS anytime soon?

View 6 Replies View Related

DB Engine :: Connection To Server Instance From SSMS Fails Without Specifying Port

Oct 27, 2015

connecting to a SQL Server Instance. I have a SQL server DB on a server having an Instance not running on the default port. Let's say ServerAInstanceA has the services exposed on Port 12345. When I'm trying to connect to ServerAInstanceA without specifying the port number, while I can connect from one client machine (ClientA), I am unable to connect from a different client machine (ClientB).On a side note, when I provide the port number, I can connect both from clients A and B. My question is, when I do not provide the port number, why is one client machine able to connect while the other isn't?

View 4 Replies View Related

SQL Tools :: SSMS To Connect To PDW / APS?

Jun 25, 2015

Is there a roadmap for allowing SSMS to connect to a PDW (MS SQL2012 Parallel Data Warehouse) with full functionality? Current support leaves much to be desired without installing third party tools.

View 3 Replies View Related

SSMS Performing Slow Over Remote Connection?

Mar 25, 2013

One of the instance is hosted in a cluster node with 128GB of ram and 80 processors allocated to this instance...And last week, we had an issue with temp DB as it was full.We increased the drive space over the weekend.

Now whenever we connect this instance from other server through remote SSMS, we see, refreshing the object including connecting to this instance is very very slow...It takes more than 10 sec. Initially this was not the case. Even hear from end user that the application is performing gradually slow.

I check the network, fregmentation, settings across this instance, and all looks good.

View 2 Replies View Related

SQL 2012 :: Login Failure For SSMS

Jun 24, 2014

I am not able to login to the SSMS, while I am logging I got this error, how to troubleshoot..

Cannot connect to LAASYA.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

[URL]

------------------------------
The system cannot find the file specified
------------------------------
BUTTONS:
OK
------------------------------

View 6 Replies View Related

SSMS - Intermittent Login Failure

Mar 31, 2006

I have a 2000 / 2005 side-by-side installation on our test server.

To login to 2005 with SSMS, the connect string is

hostname/SQL2005, 1434

There's a WiFi network connecting my client PC to the network.

SSMS fails to login frequently. I need to exit SSMS, then login again. It'll work.

A new problem today - after successful login, I can't open a project and login successfully. Error messages states "Failed to Login".

Any tips?

Sam

View 1 Replies View Related

SSMS Cannot Connect Through Object Explorer To Anything

May 16, 2006

I've installed SQL Server 2005 SP1 RTM on a Windows 2003 R2 machine (machine A), and my local workstation (machine B).

From machine B, I can use SSMS to connect to SQL Server on machine A. This is using either "New Query" or "Object Explorer".

However, on machine A, SSMS can only connect to machines A or B using the "New Query" option. If I try "Object Explorer" for either, I get the error message "Failed to retrieve data for this request... urn could not be resolved at level Configuration."

I'm not sure what died (no pun intended) since the last time this worked. Any thoughts on this?

View 1 Replies View Related

SSMS Fails To Connect To SQL 2005

Sep 21, 2007

We are running SQL 2005 Standard on Windows 2000 Server Standard. We are trying to connect via SSMS with the Object Explorer to the server and it is failing with an error message stating:



"An exception occurred while executing a Transact-SQL statement or batch.

Additional Information:
Error executing extended stored procedure: Invalid Parameter (Microsoft SQL Server, Error: 22001)

Using profiler, I tracked down that it is a call to xp_instance_regread. This is something that SSMS is issuing - not me.

We've found in the past that rebooting the server fixes the problem. But it keeps cropping up. The only thing running on this server is SQL 2005 - so if something is monkeying with the registry - it's got to be SQL Server itself.

Querying works just fine - we can use the editor to perform queries without any issue - it's just explorer that goes kaboom.

We have SP2a installed on the server and on most (if not all) of the clients.

This is getting frustrating because it's a production server and we're having to reboot this to fix it.

View 12 Replies View Related

Unable To Connect To SSRS Within SSMS

Apr 9, 2008

Hi,
In a nutshell I'm unable to connect to SSRS within SSMS yet I can connect to SSIS, SSAS and the Database Engine within SSMS from the same named server instance ("BOODEMO")

"SQL Server 2005 Surface Area Configuration" reports that service status SSRS (DEMO) is running.

The only other problem that I have found which may be linked is that within "Reporting Services Configuration Manager BOODEMO" there is a red circled crossed next to "Report Manager Virtual Directory", yet this application has just recently reported that I successfully created a virtual directory.

Any help or constructive guidance would be greatly appreciated.

Thanks in advance,

Kieran.

View 8 Replies View Related

SSMS 2012 - Connect To Server Box

Sep 15, 2015

Every time I start SSMS 2012 the "Connect to Server" box is partially obscured in that the top of it, the move bar can't be accessed. I've manually moved it using "alt+space" then "M" followed by the arrow keys, but it's getting annoying.  Is there any way to change the initial start position of this box? 

View 6 Replies View Related

Can't Login With Localhost, But Can Login With &&<Machine Name&&>&&<Instance Name&&>, WHY?

Feb 26, 2008

Hello, when I setup Sql Server, I named my instance FIRE.

When I try to login to sql in .NET using a SqlConnection, opening the connection with:

"Data Source=localhsot;Initial Catalog=Database;Integrated Security=True;" fails, but if I use:

"Data Source=machineNameInstanceName;Initial Catalog=Database;Integrated Security=True;" it succeeds fine.

Does anyone know why this is so?

Thanks,
Saied

View 3 Replies View Related

SQL 2012 :: Can't Connect To Reporting Services From SSMS

Nov 17, 2014

I am working with SSRS. I do have admin rights. I can connect to the url https://localhost/Reports and can create the new reports and subscription. Delete the reports and subscriptions.

But when I tried to connect to Reporting Services from SSMS, I am getting below error.

I used the windows authentication. It is showing that the user name or password is not valid or you don't have permission to access this server

I can connect to the database engine and Integration services but unable to connect to the Reporting services.

View 4 Replies View Related

User Un-able To Connect To Integrated Services Within SSMS

Apr 17, 2008


Hi,
I am able to run an SSIS script from BI Visual Studio no problem, I am also able to connect to SSIS within SSMS successfully. I have system access rights to the Database Engine of the same server name.

However I have a user who also has full system access rights to the Database Engine of the same server name. However he can only connect to the database engine, he cannot connect to SSIS within SSMS, but he can successfully execute a SSIS script within BI Visual Studio which is targeted to the same server name which he can€™t connect to within SSMS.

Any help would be greatly appreciated.

Kind Regards,

Kieran.

View 5 Replies View Related

SQL Security :: Restricting Users To Login To Database Using SSMS

Jun 9, 2015

we have an application which lets users connect to production database with windows credentials, They are able access the sql tables too with windows login. I want to restrict them from accessing the sql tables. How do I do that.?I tried a db_deny but that prevented them from accessing the application too.

View 10 Replies View Related

SQL 2012 :: SSMS Not Connect After Change Port 1433

Feb 19, 2015

Version: SQL SERVER 2012 enterprise edition and SP2.

Due to one of the security reason, I have changed default port 1433 to another port number in configuration manger tools->protocols for MSSQLSERVER->TCP/IP --> IP ALL section mention another port number.

After restarted service, SQL SSMS able to connect server itself and new port number also LISTENING.

But SQL client SSMS not connected to one of the PC side after changing default port.

View 3 Replies View Related

Cannot Connect To Server Through Ssms - Cannot Generate Sspi Context

Aug 1, 2007

Hi,

I have gone through so many kb articles to understanding the problem, but no luck as yet.

Here is the situation:

I have two dev servers : Server A and Server B. Both are set up in an identical fashion. Windows 2003 sp2, Sql Server 2005 sp1 Developer Edition, both are on the same domain, Both have all the three protocols enabled: Shared Memory, Tcpip, and Named Pipes in that order. I can ping both servers, and telnet using the default port. Both have only default instances. Both use the same domain user account for sql service. Both have the error in the log saying that spn could not be registered so authentication may fall back to NTLM.

Here is the issue: When I try to register Server A specifying tcp-ip connection, I am successful and I can see that the authentication is NTLM - is as expected. since the spn registration did not happen and since the sqlservice account is not a domain admin, the authentication used NTLM over tcp-ip. However, I try to register Server B specifying tcpip, I get a cannot generate sspi context error. Why did the authentication not fall back to NTLM as in Server A? From what I read in the KB articles, I asked our network admin to check up the spn, but he assures me that spn were never manually registered.

Can somebody throw more light on this issue?

Thanks
KRSE

View 1 Replies View Related

SQL Server Admin 2014 :: Deny SSMS Connections From Remote Servers?

Nov 20, 2014

Is there any way I can deny connection from SSMS only from remote servers?

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved