Showing posts with label additional. Show all posts
Showing posts with label additional. Show all posts

Friday, March 9, 2012

MySql and Sql question

The vast Majority of Hosting services use MySql so my Question is " Can MySql Utilize a SQL Database without alot of additional work? " if not what needs to be done so the SQL Files can run on MySql..

Thxs in Advance ...

No - the two file types are binarily incompatible. But you can install the ODBC driver for MySQL and run a single query in SQL Server to access the MySQL data directly inside SQL Server.

Buck

MySql and Sql question

The vast Majority of Hosting services use MySql so my Question is " Can MySql Utilize a SQL Database without alot of additional work? " if not what needs to be done so the SQL Files can run on MySql..

Thxs in Advance ...

No - the two file types are binarily incompatible. But you can install the ODBC driver for MySQL and run a single query in SQL Server to access the MySQL data directly inside SQL Server.

Buck

Saturday, February 25, 2012

MY SQL server can not connect with my PC

HI

I have a peoblem when I make connect the SQL server with my PC

and this message apper

{

cannot connect to PC.......\SQLEXPRESS

Additional information:

An error has occurred while establishing a connection to the serves . When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection.( provider: SQL Network Interface , error:26 - Error locating

Server/ Instance Specified) ( Microsoft SQL Server )

}

can you help me pleas .....

You need to explicitly enable remote connections for SQL Express since they are off by default. You can enable them during install using the DISABLENETWORKPROTOCOLS flag:

(From template.ini)

;--
; The DISABLENETWORKPROTOCOLS switch is used to disable network protocol for SQL Server instance.
; Set DISABLENETWORKPROTOCOLS = 0; for Shared Memory= On, Named Pipe= On, TCP= On
; Set DISABLENETWORKPROTOCOLS = 1; for Shared Memory= On, Named Pipe= Off (Local Only), TCP= Off
; Set DISABLENETWORKPROTOCOLS = 2; for Shared Memory= On, Named Pipe= Off (Local Only), TCP= On

; Note: DISABLENETWORKPROTOCOLS if not specified has the following defaults.
; Default value for SQL Server Express/Evaluation/Developer: DISABLENETWORKPROTOCOLS =1
; Default value for Enterprise/Standard /Workgroup: DISABLENETWORKPROTOCOLS =2

or after install using TSQL or following this blog:

http://support.microsoft.com/kb/914277

Thanks,
Sam Lester (MSFT)

|||

I have been struggling with this for about a week now. For some reason today when I searched I found this thread relatively quickly, and this reply held the solution.

For me, it was the single line of text "Turn on the SQL Server Browser Service." that solved the problem.

SQL Server Browser Service was not running on my server. I had to use the SQL Server Surface Area Configuration Tool to enable and start the SQL Server Browser Service. As soon as that worked, I had no problems.

Thanks.

Jim Sparks