Please Resolve my problem in connecting to server

[former_member204303]

Dear Experts,

I have a connectivity issue with the client.Im getting the follwing error.

Connection Failed:

SQL State :'01000'

SQL Server Error:1326

[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection open (Connect()).

Connection Failed:

SQL State :'08001'

SQL Server Error:17

[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied.

Please help me to resolve the problem

Warm regards,

V.Kesevan

9392579731

[Former Member · Accepted solution]

Check SAP Note: 1015229 B1 Client installation with SQL 2005

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=1015229]

[former_member204303 · Accepted solution]

Dear Sridharan,

I have tried as you have suggested.But still im facing the same problem.

Warm Regards,

V.Kesevan.

[Former Member · Accepted solution]

Were you able to install SBO Client?

[former_member204303 · Accepted solution]

ya i can able to and i have installed SBO

[Former Member · Accepted solution]

Is your problem solved or do you facing the same problem ?

[Former Member]

Hi Experts

I'm facing similar kind of issue with SQL database server while installing SAP NetWeaver Gateway in distributed environment. Can you please check below thread and let me know your expert advice/views:

SQL server doesn't exist or access denied || SA... | SCN

Regards

Hardeep

[Former Member]

Dear Kesevan,

Could you please try the steps as per the below link :-

http://social.msdn.microsoft.com/forums/en-US/sqlgetstarted/thread/27684811-1a59-4273-b7ed-3cc990b4f...

Note : Please make sure that you have installed the SQL Server Native client.

Regards,

Rakesh Pati

SAP Business One Forum Team

[former_member204303]

Thanks a lot for reply experts.

I can able to view my database but when i try to open a database, i get a window,where i should enter the IP address or Licence server name.After entering i get "Connection to the Licence server failed [Message 60070-15].

Please guide me to go a head.

Warm regards,

V.Keseva.

9392579731.

[Former Member]

Hi Keseva,

You probably need to install Licence manager from server tools. If you have already installed it then it should appear in the server manager. You just need to start the service.

Have a look at your taskbar server manager should appear there.

Let me know if you still having any problems

Kamran

[mario_schoenberg]

Hi V.Kesevan,

Refer to [http://support.microsoft.com/kb/555105 |http://support.microsoft.com/kb/555105 ]and update the version of MDAC at the workstation.

Kind regards

Mario

[former_member418241]

Hi Kesavan,

Did you try to install SQL Native Client. First of all after installing the native client try to connect to the server with ODBC connection from your system. If the connection is established and able to connect to the system then the SAP B1 client application will also connect. First check with the ODBC connection through SQL Native Client. you can down load this small piece of software from the following link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=50B97994-8453-4998-8226-FA42EC403D17&displa...

SV Reddy