ifconfig loopback?

**Thesnowman** · 21-02-10

Ok so im following that guide. And when i get to the SQL Server 2005 Surface config part i get this error:

Code:

TITLE: Surface Area Configuration
------------------------------

Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.InnerWmiException&LinkId=20476

------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

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

------------------------------

The operation could not be completed. (WinMgmt)

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

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

But i know i have sql installed on this machine cause SQL management can connect no problem.

**Thesnowman** · 21-02-10

bump

**FastBlade** · 21-02-10

Originally Posted by Thesnowman

so then i tried 71.59.174.158 cause in cabal config it asked if i wanted to find my WAN and thats what it said. So then it still loads all the blue bar then says failed to connect. Like its not getting response. Doesnt even say "wrong user or pass" like it should when its actually connected.

as far as i know if you put in centos your wan ip you cant connect with cabal on the same pc,and if you did the setup of centos corect that means you messed something up at mssql,enter chumpy's code in mssql in a new querry in any db and see if it's instaled corect,if not follow chumpy's guide carefull..

**Thesnowman** · 21-02-10

So you mean if the centos is set up properly and if u look in my login log up there ull see im trying to connect. I cant connect to cabal on this machine? Ill have to use my laptop?

In my DBagent09_log it says this:

Code:

[Sun Feb 21 2010 12:46:07.477923 3086952128]: open log file  '/var/log/cabal/DBAgent_09.log'
[Sun Feb 21 2010 12:46:07.477923 3086952128]: LOG LEVEL: 3
[Sun Feb 21 2010 12:46:07.477923 3086952128]: MemPoolUnitSizeClass(2): 24576Bytes
[Sun Feb 21 2010 12:46:07.481934 3086952128]: Start DBAgent_09 Server
[Sun Feb 21 2010 12:46:07.484339 3086952128]: UseEcryptText (Off)
[Sun Feb 21 2010 12:46:07.485419 3086952128]: try listening 38181 port
[Sun Feb 21 2010 12:46:07.488935 3086949280]: CProcessLayer(0)::svc Start [3086949280]
[Sun Feb 21 2010 12:46:07.489403 3076459424]: CProcessLayer(0)::svc Start [3076459424]
[Sun Feb 21 2010 12:46:07.489962 3065969568]: CProcessLayer(0)::svc Start [3065969568]
[Sun Feb 21 2010 12:46:07.490366 3055479712]: CProcessLayer(0)::svc Start [3055479712]
[Sun Feb 21 2010 12:46:07.490973 3044989856]: CProcessLayer(0)::svc Start [3044989856]
[Sun Feb 21 2010 12:46:08.618152 3086952128]: accept success 8(127.0.0.1:33294)
[Sun Feb 21 2010 12:46:08.622806 3086952128]: 1.open user 8 [9961440] (127.0.0.1)
[Sun Feb 21 2010 12:46:09.812067 3086952128]: accept success 10(127.0.0.1:33296)
[Sun Feb 21 2010 12:46:09.813450 3086952128]: 2.open user 10 [996FB80] (127.0.0.1)
[Sun Feb 21 2010 12:46:11.841677 3086952128]: accept success 11(127.0.0.1:33300)
[Sun Feb 21 2010 12:46:11.842923 3086952128]: 3.open user 11 [997BD90] (127.0.0.1)
[Sun Feb 21 2010 12:46:15.751184 3086952128]: accept success 12(127.0.0.1:33304)
[Sun Feb 21 2010 12:46:15.751184 3086952128]: 4.open user 12 [9987FE0] (127.0.0.1)
[Sun Feb 21 2010 12:47:05.797958 3065969568]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Feb 21 2010 12:47:05.799176 3076459424]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] Database Connect Fail (uid=cabaladmin;pwd=cabalserver;dsn=CabalGame09;APP=DBAgent_09)
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] check 'pDB' fail
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Sun Feb 21 2010 12:47:05.799646 3044989856]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Feb 21 2010 12:47:05.868818 3044989856]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sun Feb 21 2010 12:47:05.868839 3044989856]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sun Feb 21 2010 12:47:05.868860 3044989856]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sun Feb 21 2010 12:47:05.868879 3044989856]: [##ERROR##] DB ERROR(STM_TEXT) : 
And many more.........

But i know the details are right.

---------- Post added at 09:16 PM ---------- Previous post was at 08:43 PM ----------

See post above but also Chumpys tools cant connect either.

I know i installed MSSQL 2005 properly. The only thing i didnt do was the surface area config cause i get this error:

Code:

TITLE: Surface Area Configuration
------------------------------

Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.InnerWmiException&LinkId=20476

------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

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

------------------------------

The operation could not be completed. (WinMgmt)

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

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

And chumpys tools say:

Code:

MSSQL Server did not respond.
Check server IP (Must be a IP not a hostname) and make sure your username and password are correct. 

Also make sure no firewall is in the way.

The IP is 127.0.0.1 and i know the User and pass are correct. I see it clear as day in my MSSQL server management

**FastBlade** · 22-02-10

Originally Posted by Thesnowman

So you mean if the centos is set up properly and if u look in my login log up there ull see im trying to connect. I cant connect to cabal on this machine? Ill have to use my laptop?

In my DBagent09_log it says this:

Code:

[Sun Feb 21 2010 12:46:07.477923 3086952128]: open log file  '/var/log/cabal/DBAgent_09.log'
[Sun Feb 21 2010 12:46:07.477923 3086952128]: LOG LEVEL: 3
[Sun Feb 21 2010 12:46:07.477923 3086952128]: MemPoolUnitSizeClass(2): 24576Bytes
[Sun Feb 21 2010 12:46:07.481934 3086952128]: Start DBAgent_09 Server
[Sun Feb 21 2010 12:46:07.484339 3086952128]: UseEcryptText (Off)
[Sun Feb 21 2010 12:46:07.485419 3086952128]: try listening 38181 port
[Sun Feb 21 2010 12:46:07.488935 3086949280]: CProcessLayer(0)::svc Start [3086949280]
[Sun Feb 21 2010 12:46:07.489403 3076459424]: CProcessLayer(0)::svc Start [3076459424]
[Sun Feb 21 2010 12:46:07.489962 3065969568]: CProcessLayer(0)::svc Start [3065969568]
[Sun Feb 21 2010 12:46:07.490366 3055479712]: CProcessLayer(0)::svc Start [3055479712]
[Sun Feb 21 2010 12:46:07.490973 3044989856]: CProcessLayer(0)::svc Start [3044989856]
[Sun Feb 21 2010 12:46:08.618152 3086952128]: accept success 8(127.0.0.1:33294)
[Sun Feb 21 2010 12:46:08.622806 3086952128]: 1.open user 8 [9961440] (127.0.0.1)
[Sun Feb 21 2010 12:46:09.812067 3086952128]: accept success 10(127.0.0.1:33296)
[Sun Feb 21 2010 12:46:09.813450 3086952128]: 2.open user 10 [996FB80] (127.0.0.1)
[Sun Feb 21 2010 12:46:11.841677 3086952128]: accept success 11(127.0.0.1:33300)
[Sun Feb 21 2010 12:46:11.842923 3086952128]: 3.open user 11 [997BD90] (127.0.0.1)
[Sun Feb 21 2010 12:46:15.751184 3086952128]: accept success 12(127.0.0.1:33304)
[Sun Feb 21 2010 12:46:15.751184 3086952128]: 4.open user 12 [9987FE0] (127.0.0.1)
[Sun Feb 21 2010 12:47:05.797958 3065969568]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Feb 21 2010 12:47:05.799176 3076459424]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] Database Connect Fail (uid=cabaladmin;pwd=cabalserver;dsn=CabalGame09;APP=DBAgent_09)
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] check 'pDB' fail
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Sun Feb 21 2010 12:47:05.799646 3044989856]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Feb 21 2010 12:47:05.868818 3044989856]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sun Feb 21 2010 12:47:05.868839 3044989856]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sun Feb 21 2010 12:47:05.868860 3044989856]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sun Feb 21 2010 12:47:05.868879 3044989856]: [##ERROR##] DB ERROR(STM_TEXT) : 
And many more.........

But i know the details are right.

---------- Post added at 09:16 PM ---------- Previous post was at 08:43 PM ----------

See post above but also Chumpys tools cant connect either.

I know i installed MSSQL 2005 properly. The only thing i didnt do was the surface area config cause i get this error:

Code:

TITLE: Surface Area Configuration
------------------------------

Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.InnerWmiException&LinkId=20476

------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

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

------------------------------

The operation could not be completed. (WinMgmt)

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

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

And chumpys tools say:

Code:

MSSQL Server did not respond.
Check server IP (Must be a IP not a hostname) and make sure your username and password are correct. 

Also make sure no firewall is in the way.

The IP is 127.0.0.1 and i know the User and pass are correct. I see it clear as day in my MSSQL server management

well i'm not very good in reading logs,but try to setup centos with WAN ip,then connect to cabal from another PC,also you have to forward the ports,
(here is the link to the guide).Try that and tell us the results.

**Thesnowman** · 22-02-10

Reading logs arnt hard dude...

**FastBlade** · 22-02-10

Originally Posted by Thesnowman

Reading logs arnt hard dude...

i'm just a begginer dude

ifconfig loopback?

Thread Tools

Re: ifconfig loopback?

Re: ifconfig loopback?

Re: ifconfig loopback?

Re: ifconfig loopback?

Re: ifconfig loopback?

Re: ifconfig loopback?

Re: ifconfig loopback?

Advertisement