1433 is just the default port, you need to find out what port you are using it and use that to test it. Log into the database server directly, open a cmd window and type hostname. Port is grey - 1433Data base has a default of 1433, and normally it looks for the (local) server and data base name with passcode. When you say server name- the one that came up when I set up SQL-Server? then go to the port and put in my 1433?SherryĬurrntly:TCI/pc- Server is. Try via TCP/IP: serverName,portNumberIf that works and you don't want to remember the port, then I can help you setup an alias.Tara Kizer Microsoft MVP for Windows Server System - SQL Server Subscribe to my blog
#SQL ERROR 18456 MIXED MODE DRIVER#
I am getting this:connection failed:SQL State: '01000'SQL Server Error: 14(Microsoft)(ODBCSQL Server Driver)(Shared memory)(Connection Open)(Invalid Instance()Connection FailedSQL State: '08001SQL Server Error 14MicrosoftODBCSQL Server Driver Shared Memory invaid connectionWhat am I doing wrong? My test in OCBC to the database fails each time.Any help is appreciated.Sherry I have Master computer using SQL 2005 express. We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.