Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Can I change connection from Named Pipes to TcpIp?

database

The SQL Server housing the Gemini db now has named pipes disabled, and Gemini can no longer connect. Is there a way to set it to use TcpIp instead?

Using v3.6.3.
Jim Peppercorn
· 1 		Jim Peppercorn
Thursday, June 23, 2011, 3:15:22 PM
Replies (8)
helpful
0
not helpful

Add ;Network Library=DBMSSOCN to the connection string. Make sure TCP/IP is enabled for SQL Server
Mark Wing
· 9108 		Mark Wing
Thursday, June 23, 2011, 3:26:23 PM
helpful
0
not helpful

Connection string is:

Server=192.168.100.xxx; Initial Catalog=GeminiV36; uid=username; pwd=password; Network Library=DBMSSOCN

But, I still get the Named Pipes error. Yes, I restarted IIS 7.

provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
Jim Peppercorn
· 1 		Jim Peppercorn
Thursday, June 23, 2011, 3:36:55 PM
helpful
0
not helpful
ANSWER

Please try

Data Source=192.168.100.xxx;Network Library=DBMSSOCN;Initial Catalog=GeminiV36;User ID=username;Password=password;
Mark Wing
· 9108 		Mark Wing
Thursday, June 23, 2011, 3:43:08 PM
helpful
0
not helpful

Still get the same error.
Jim Peppercorn
· 1 		Jim Peppercorn
Thursday, June 23, 2011, 3:51:54 PM
helpful
0
not helpful

rebooting...
Jim Peppercorn
· 1 		Jim Peppercorn
Thursday, June 23, 2011, 3:55:42 PM
helpful
0
not helpful

Noope still get the same error:

provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
Jim Peppercorn
· 1 		Jim Peppercorn
Thursday, June 23, 2011, 4:02:34 PM
helpful
0
not helpful

Are you sure that TCP IP is enabled? Also try putting the port after the IP: 192.168.100.xxx,1433
Mark Wing
· 9108 		Mark Wing
Thursday, June 23, 2011, 4:22:13 PM
helpful
0
not helpful

It finally worked. No idea why it took so long, but all is well.

Yes, tcp ip is enabled, I even connected using the ODBC connection manager with tcp ip.

Thanks.
Jim Peppercorn
· 1 		Jim Peppercorn
Thursday, June 23, 2011, 4:29:09 PM