SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 MSSQL 2008 Help and DB
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 02/21/2012 :  17:44:19  Show Profile  Visit tkizer's Homepage  Reply with Quote
If the database server is remote, then you can't use 127.0.0.1 to connect to it. Use the database server's name or actual IP address.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 02/21/2012 :  17:45:24  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by kofta01


well why i dont use sa account?



For security reasons you should not use the sa account. Create an account that has the minimum permissions your application needs and use that in the application's connection string. Using sa is lazy and just going to cause issues down the road.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/21/2012 :  17:55:50  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
127.0.0.1 is the loop-back address for the local machine. In other words, it always points to the machine that you are using. So the only time you'd use that is when the SQL Server is on the same machine as you are connecting from, and in that case you'd probably rather use (local)

--
Gail Shaw
SQL Server MVP
Go to Top of Page

kofta01
Starting Member

16 Posts

Posted - 02/21/2012 :  19:03:10  Show Profile  Reply with Quote
well about this 127.0.0.1
i already tried to use the public ip=Dedi Server IP
still the same problem
..about make new acc
i will try this
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 02/21/2012 :  19:06:58  Show Profile  Visit tkizer's Homepage  Reply with Quote
You probably don't have your network/firewall configured properly to allow the application server to communicate to the database server's listening port.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

kofta01
Starting Member

16 Posts

Posted - 02/21/2012 :  19:37:50  Show Profile  Reply with Quote
Firewall Already off
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 02/21/2012 :  21:42:06  Show Profile  Visit tkizer's Homepage  Reply with Quote
You can use this article that I wrote to troubleshoot the problem: http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

One of the key steps is the telnet test.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

kofta01
Starting Member

16 Posts

Posted - 02/21/2012 :  22:30:53  Show Profile  Reply with Quote
iam using 2008 r2
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 02/21/2012 :  22:46:05  Show Profile  Visit tkizer's Homepage  Reply with Quote
Doesn't matter, same troubleshooting steps.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

kofta01
Starting Member

16 Posts

Posted - 02/21/2012 :  22:56:47  Show Profile  Reply with Quote
this not the errors i get -.-
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 02/22/2012 :  00:06:30  Show Profile  Visit tkizer's Homepage  Reply with Quote
Doesn't matter. Troubleshooting steps are still the same. The Telnet test is the key piece here. Let us know how that goes.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

kofta01
Starting Member

16 Posts

Posted - 02/22/2012 :  17:32:16  Show Profile  Reply with Quote
ok i changed to MYSql
you guys still support problems from it too?
here the problem iam facing
http://img813.imageshack.us/img813/1864/dsdssssssssssssssssssss.png
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 02/22/2012 :  17:47:29  Show Profile  Reply with Quote
This site is for support of Microsoft SQL Server, so there is no support for MySQL here.

Try this site:
http://www.dbforums.com/mysql/





CODO ERGO SUM
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 02/22/2012 :  17:49:22  Show Profile  Visit tkizer's Homepage  Reply with Quote
Wow, shakes my head! This is totally resolvable in SQL Server. Did you even do a telnet test?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

kofta01
Starting Member

16 Posts

Posted - 02/22/2012 :  17:55:37  Show Profile  Reply with Quote
i dont know what you mean by telnet
also my DB
his type =.SQL
and so MSSQL can run it?
or MySql who can?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 02/22/2012 :  17:58:34  Show Profile  Visit tkizer's Homepage  Reply with Quote
Apparently you didn't go through the link I posted as it goes into great detail how to do it. I give up.

Any program can run a .sql file. Whether or not it'll run successfully is another story. Talk to the person who wrote it to find out what it requires. We can't answer that for you.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 03/07/2012 :  14:03:56  Show Profile  Reply with Quote
quote:
Originally posted by GilaMonster

My billing rate is $120/hour, with a minimum of 8 hours.

If you want personal consulting (and connecting to your server counts), you'll need to pay for it. If you are interested, let me know.

--
Gail Shaw
SQL Server MVP



Is that under the table?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000