Questions in topic: "connectivity"https://ask.sqlservercentral.com/questions/topics/single/1033.html
The latest questions for the topic "connectivity"ODBC dsn not showing new tableshttps://ask.sqlservercentral.com/questions/140592/odbc-dsn-not-showing-new-tables.html
Server: SQL Server 2012 SP3 / Windows Server 2012
Client: Windows 7 Pro 64 bit, SQLCLN 11
I have a user trying to retrieve tables from a SQL 2012 default instance. User has db_datareader permissions on the database. After setting up the ODBC connection, if I add a new table (WAREHOUSE.NewTable1), it does not show in the list of available tables in the ODBC connection. The user can select and view all tables in the database, including all tables in the WAREHOUSE schema, except this particular table.
What I've tried so far:
1. Have the user connect via SSMS - Success, user can view the table
2. Have the user recreate the ODBC connection - Fail, user cannot view table
3. Add new table other than WAREHOUSE.NewTable1 - Success, user can select from added table, in any schema
4. Explicitly add the schema permissions to the user - Fail, user cannot view table
I am convinced that it is not on the SQL Server side (security / permissions). I believe it to be in the ODBC connection, but don't know where, since it is pretty much a black box without a ton of configuration. I have seen a problem with 32 bit ODBC vs 64 bit ODBC but that was connecting to a legacy AS400 data source and I'm pretty sure that isn't a problem here. Any ideas?connectionodbcsql 2012connectivityWed, 19 Oct 2016 15:52:02 GMTtdknight9SQL form queryhttps://ask.sqlservercentral.com/questions/137848/sql-form-query.html
I made a username and submit button on a 1 php page.When u enter the username and click submit button new page will opened and give the whole info of that username.I just want to know the sql query to retrieve the data of that particular user
Select * from where username=sql queryconnectivityformsThu, 14 Apr 2016 05:53:26 GMTshubham1610Getting ORA-12170: TNS:Connect timeout occurred when trying to TEST Connection on linked server.https://ask.sqlservercentral.com/questions/115124/getting-ora-12170-tnsconnect-timeout-occurred-when.html
Hi,
Getting ORA-12170: TNS:Connect timeout occurred when trying to TEST Connection on linked server.
Checked the connectivity from the oracle side and it shows successful.
Checked the TNS entry in tnsnames.ora and was able to tnsping the service ID.
Also able to Telnet the Service ID.
From sQLPLUS the connection is showing successful but when trying to test the connection from the SSMS Linked server its failing with ORA-12170: TNS:Connect timeout.
Any suggestions on why we are getting this error?
Thanks.oraclelinked-serverconnectivityFri, 26 Sep 2014 08:43:20 GMTDeepakSahuhow to connect ssis connection in sql server?https://ask.sqlservercentral.com/questions/115076/how-to-connect-ssis-connection-in-sql-server.html
when i'm trying to connect to ssis services in MSBI i got This Error Please Expalin
Connecting to the Integration Services service on the computer "JAI" failed with the following error: "Access is denied."
By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.ssisssmsadministrationconnectivityWed, 24 Sep 2014 11:54:51 GMTcrazyCoolguyConnectivity to 2005 and 2008 from same workstationhttps://ask.sqlservercentral.com/questions/86393/connectivity-to-2005-and-2008-from-same-workstatio.html
I have databases on both MSSQL 2005 and 2008. On my workstation I have Microsoft SQL Server Management Studio version 10.0.5500.0. I have set up DSN for both of my databases (1 2005 and 1- 2008) and can use my tool to connect to the 2008 database, but get the following error in my log when I try to test the 2005 connection (this is a peoplesoft specific tool, I can connect with all other tools to both instances).
RC=0 Dur=0.000000 XER rtncd=0 **msg=Invalid SQL Server version (minimum is SQL Server 2008)** (SQLSTATE PS078)
My Question is: Can you access both MSSQL 2005 and 2008 from the same windows machine using the SQL Server Native Client 10.0? If so, then what am I missing in the setup? I did set up with both the 32-bit and the 64-bit version of odbc.sql-server-2008clientconnectivityTue, 07 Feb 2012 18:35:21 GMTtburroweBiztalk Server 2004 AND SQL adapter errorhttps://ask.sqlservercentral.com/questions/47276/biztalk-server-2004-and-sql-adapter-error.html
Hi,
I am seenig the below error messages on the Biztalk Server Event viewer. I am not that aware the Biztalk functioning and would like to know when such errors occur:
The Biztalk server connects to SQL Server 2000 Instance mentioned below as
InstanceName.
----------------------------------------------------------------
13h30,45s => The "SQL" adapter is suspending an outbound message going to destination URL:"SQL://Servername/InstanceName/DatabaseName/". Details:"[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. ".
13h30,45s => The Messaging Engine has suspended "1" message(s) from adapter "SQL" due to failures in message processing. Please refer to Health and Activity Tracking tool for more detailed information on this failure.
13h30,45s =>The adapter failed to transmit message going to send port "SQL://Servername/InstanceName/DatabaseName/". It will be retransmitted after the retry interval specified for this Send Port. Details:"Unspecified error".
--------------------------------------------------------------------
Any help is highly appreciated!!!sql-server-2005connectionconnectivitybiztalkTue, 04 Oct 2011 02:44:21 GMTMandar Alawanierror messagehttps://ask.sqlservercentral.com/questions/41976/error-message.html
Hi,
One of upload job is failing with following error message...
Failed to connecto to the data server Inner Error ------------------> Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Login timeout expired" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}. Row #: 1 Source: "Microsoft SQL Server Native Client 10.0" Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online." Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}. Row#: 2 Source: "Microsoft SQL Server Native Client 10.0" Instance: "" Procedure: "" Line#: 0 Error Number: 2 Error State: 1 Error Severity: 16 Error Message: "Named Pipes Provider: Could not open a connection to SQL Server [2]. " Help File: "(null)", Help context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}. OLE DB Error Record dump end. Process Exit Code 1. The step failed.
can you please let me know what is the reason? how can I resolve it?
The job is running with correct authentication.
regards.errorconnectionconnectivitymessageTue, 21 Jun 2011 03:34:29 GMTpits