MySQL Linked Server

I am trying to set up mysql as linked server for SQL Server 2000.
These are the steps I already have taken.
1- Installation of MyODBC 3.51 driver
2- Creation of ODBC Data source with name 'MySQLODBC' and connecting to
'mysql' data source
Now what I need to have is a SQL commands to add it as a linked server?
OR
What do I specify for the following fields by using Enterprise Manager
a) Provider Name
b) Data source
c) Provider string
d) Location
e) Catalog
I am using default 'root' account without any password.Asaf,
Check help for "sp_addlinkedserver" in MS SQL Server documentation. This
is what you have to use to create the link
Asaf wrote:
> I am trying to set up mysql as linked server for SQL Server 2000.
> These are the steps I already have taken.
> 1- Installation of MyODBC 3.51 driver
> 2- Creation of ODBC Data source with name 'MySQLODBC' and connecting to
> 'mysql' data source
> Now what I need to have is a SQL commands to add it as a linked server?
> OR
> What do I specify for the following fields by using Enterprise Manager
> a) Provider Name
> b) Data source
> c) Provider string
> d) Location
> e) Catalog
> I am using default 'root' account without any password.|||Thanks for your reply Dennis but my problem is still the same. Being novice
I
have no idea what I specify for all sp_addlinkedserver parameters such as
sp_addlinkedserver [ @.server = ] 'server'
[ , [ @.srvproduct = ] 'product_name' ]
[ , [ @.provider = ] 'provider_name' ]
[ , [ @.datasrc = ] 'data_source' ]
[ , [ @.location = ] 'location' ]
[ , [ @.provstr = ] 'provider_string' ]
[ , [ @.catalog = ] 'catalog' ]
I would appreciate if someone out there could provide me a complete
sp_addlinkedserver with all parameters for MySQL.
"Dennis Black" wrote:

> Asaf,
> Check help for "sp_addlinkedserver" in MS SQL Server documentation. This
> is what you have to use to create the link
>
> Asaf wrote:
>|||Dennis, this is what I have done
exec sp_addlinkedserver
@.server = 'DefaultMySQL'
, @.srvproduct = 'MySQLProv'
, @.provider = 'MSDASQL'
, @.datasrc = 'MySqlDSN'
, @.location = NULL
, @.provstr = NULL
, @.catalog = 'mysql'
This is the error message
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'MSDASQL' in sysservers.
Would you please help
"Dennis Black" wrote:

> Asaf,
> Check help for "sp_addlinkedserver" in MS SQL Server documentation. This
> is what you have to use to create the link
>
> Asaf wrote:
>|||Here is an example where I link a mysql database to SQL Server:
sp_addlinkedserver
@.server='YouServer', -- This could be anything
@.srvproduct='MySQL', -- This could be anything
@.provider='MSDASQL', -- This MUST be MSDASQL for ODBC links
@.datasrc='ODBC_DSN_NAME', -- This should be the ODBC System DSN. Do
@.provstr='DATABASE=mydb;DSN=My
DSN;OPTION=0;PWD=password;SERVER=localho
st;UID=myuser'
I use a program called WinSQL (http://synametrics.com/winsql), which
creates the Connection string. I used this connection string for the
'provstr' parameter.
Asaf wrote:[vbcol=seagreen]
> Dennis, this is what I have done
> exec sp_addlinkedserver
> @.server = 'DefaultMySQL'
> , @.srvproduct = 'MySQLProv'
> , @.provider = 'MSDASQL'
> , @.datasrc = 'MySqlDSN'
> , @.location = NULL
> , @.provstr = NULL
> , @.catalog = 'mysql'
> This is the error message
> Server: Msg 7202, Level 11, State 2, Line 1
> Could not find server 'MSDASQL' in sysservers.
> Would you please help
> "Dennis Black" wrote:
>|||Dear Dennis,
I must say you have been a great help. I have managed to successfully create
a linked server by using the following setting
exec sp_addlinkedserver
@.server='MySQLServer', -- This could be anything
@.srvproduct='MySQL', -- This could be anything
@.provider='MSDASQL', -- This MUST be MSDASQL for ODBC links
@.datasrc='MySqlODBC', -- This should be the ODBC System DSN.
@.provstr='DATABASE=mySql;DSN=MySqlODBC;O
PTION=0;PWD=;SERVER=localhost;UID=ro
ot'
There is only one more issue; I could query mysql by using e.g user Table
from mysql db.
Select * from OPENQUERY(MySQLServer, 'select * from user')
but usual sql server syntax
SELECT * FROM MySQLServer.mySQL.dbo.[user]
generates an error message
"Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A
four-part name was supplied, but the provider does not expose the necessary
interfaces to use a catalog and/or schema."
What is it that I am doing wrong ?
"Dennis Black" wrote:

> Here is an example where I link a mysql database to SQL Server:
> sp_addlinkedserver
> @.server='YouServer', -- This could be anything
> @.srvproduct='MySQL', -- This could be anything
> @.provider='MSDASQL', -- This MUST be MSDASQL for ODBC links
> @.datasrc='ODBC_DSN_NAME', -- This should be the ODBC System DSN. Do
> @.provstr='DATABASE=mydb;DSN=My
> DSN;OPTION=0;PWD=password;SERVER=localho
st;UID=myuser'
>
> I use a program called WinSQL (http://synametrics.com/winsql), which
> creates the Connection string. I used this connection string for the
> 'provstr' parameter.
>
>
>
> Asaf wrote:
>

MySQL Linked Server

I am trying to set up MySQL as linked server for SQL Server 2000.
These are the steps I already have taken.
1- Installation of MyODBC 3.51 driver
2- Creation of ODBC Data source with name 'MySQLODBC' and connecting to
'mysql' data source
Now what I need to have is a SQL commands to add it as a linked server?
OR
What do I specify for the following fields by using Enterprise Manager
a) Provider Name
b) Data source
c) Provider string
d) Location
e) Catalog
I am using default 'root' account without any password.
Asaf,
Check help for "sp_addlinkedserver" in MS SQL Server documentation. This
is what you have to use to create the link
Asaf wrote:
> I am trying to set up MySQL as linked server for SQL Server 2000.
> These are the steps I already have taken.
> 1- Installation of MyODBC 3.51 driver
> 2- Creation of ODBC Data source with name 'MySQLODBC' and connecting to
> 'mysql' data source
> Now what I need to have is a SQL commands to add it as a linked server?
> OR
> What do I specify for the following fields by using Enterprise Manager
> a) Provider Name
> b) Data source
> c) Provider string
> d) Location
> e) Catalog
> I am using default 'root' account without any password.
|||Thanks for your reply Dennis but my problem is still the same. Being novice I
have no idea what I specify for all sp_addlinkedserver parameters such as
sp_addlinkedserver [ @.server = ] 'server'
[ , [ @.srvproduct = ] 'product_name' ]
[ , [ @.provider = ] 'provider_name' ]
[ , [ @.datasrc = ] 'data_source' ]
[ , [ @.location = ] 'location' ]
[ , [ @.provstr = ] 'provider_string' ]
[ , [ @.catalog = ] 'catalog' ]
I would appreciate if someone out there could provide me a complete
sp_addlinkedserver with all parameters for MySQL.
"Dennis Black" wrote:

> Asaf,
> Check help for "sp_addlinkedserver" in MS SQL Server documentation. This
> is what you have to use to create the link
>
> Asaf wrote:
>
|||Dennis, this is what I have done
exec sp_addlinkedserver
@.server = 'DefaultMySQL'
, @.srvproduct = 'MySQLProv'
, @.provider = 'MSDASQL'
, @.datasrc = 'MySqlDSN'
, @.location = NULL
, @.provstr = NULL
, @.catalog = 'mysql'
This is the error message
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'MSDASQL' in sysservers.
Would you please help
"Dennis Black" wrote:

> Asaf,
> Check help for "sp_addlinkedserver" in MS SQL Server documentation. This
> is what you have to use to create the link
>
> Asaf wrote:
>
|||Here is an example where I link a MySQL database to SQL Server:
sp_addlinkedserver
@.server='YouServer', -- This could be anything
@.srvproduct='MySQL', -- This could be anything
@.provider='MSDASQL', -- This MUST be MSDASQL for ODBC links
@.datasrc='ODBC_DSN_NAME', -- This should be the ODBC System DSN. Do
@.provstr='DATABASE=mydb;DSN=My
DSN;OPTION=0;PWD=password;SERVER=localhost;UID=myu ser'
I use a program called WinSQL (http://synametrics.com/winsql), which
creates the Connection string. I used this connection string for the
'provstr' parameter.
Asaf wrote:[vbcol=seagreen]
> Dennis, this is what I have done
> exec sp_addlinkedserver
> @.server = 'DefaultMySQL'
> , @.srvproduct = 'MySQLProv'
> , @.provider = 'MSDASQL'
> , @.datasrc = 'MySqlDSN'
> , @.location = NULL
> , @.provstr = NULL
> , @.catalog = 'mysql'
> This is the error message
> Server: Msg 7202, Level 11, State 2, Line 1
> Could not find server 'MSDASQL' in sysservers.
> Would you please help
> "Dennis Black" wrote:
>
|||Dear Dennis,
I must say you have been a great help. I have managed to successfully create
a linked server by using the following setting
exec sp_addlinkedserver
@.server='MySQLServer', -- This could be anything
@.srvproduct='MySQL', -- This could be anything
@.provider='MSDASQL', -- This MUST be MSDASQL for ODBC links
@.datasrc='MySqlODBC', -- This should be the ODBC System DSN.
@.provstr='DATABASE=mySql;DSN=MySqlODBC;OPTION=0;PW D=;SERVER=localhost;UID=root'
There is only one more issue; I could query mySQL by using e.g user Table
from mySQL db.
Select * from OPENQUERY(MySQLServer, 'select * from user')
but usual sql server syntax
SELECT * FROM MySQLServer.mySQL.dbo.[user]
generates an error message
"Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A
four-part name was supplied, but the provider does not expose the necessary
interfaces to use a catalog and/or schema."
What is it that I am doing wrong ?
"Dennis Black" wrote:

> Here is an example where I link a MySQL database to SQL Server:
> sp_addlinkedserver
> @.server='YouServer', -- This could be anything
> @.srvproduct='MySQL', -- This could be anything
> @.provider='MSDASQL', -- This MUST be MSDASQL for ODBC links
> @.datasrc='ODBC_DSN_NAME', -- This should be the ODBC System DSN. Do
> @.provstr='DATABASE=mydb;DSN=My
> DSN;OPTION=0;PWD=password;SERVER=localhost;UID=myu ser'
>
> I use a program called WinSQL (http://synametrics.com/winsql), which
> creates the Connection string. I used this connection string for the
> 'provstr' parameter.
>
>
>
> Asaf wrote:
>

mysql installation problem in Xp

hello !

I am not able to install Mysql on my pc runnig XP
..the log file shows server is readyfor connection on port 3306.

but still client not able to server .
error comes can't connect localhaost to server on port 10061

winmysqladmin showing green indiacting server is running but server
and lient info are not there.

pls help.

smita[posted and mailed]

Smita (smitap56@.rediffmail.com) writes:
> I am not able to install Mysql on my pc runnig XP
> .the log file shows server is readyfor connection on port 3306.
> but still client not able to server .
> error comes can't connect localhaost to server on port 10061
> winmysqladmin showing green indiacting server is running but server
> and lient info are not there.

Please try http://www.mysql.com. I believe they have some support forum
there. In this group we discsuss Microsoft SQL Server, so we can't help
you.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

My Whole installation is hosed

There is a new Management Studio Express CTP download available at http://www.microsoft.com/downloads/details.aspx?FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en.

This update fixes the defect where installing the full Books Online documentation prevented Management Studio Express from starting. With the update, Management Studio Express and Books Online no longer interfere with each other.

To update Management Studio Express CTP:

1) Uninstall Management Studio Express CTP from your machine.
2) Clear your browser's download cache. If you are using Internet Explorer 6, you can do this by starting Internet Explorer, clicking the Tools | Options menu item, and then clicking the "Delete Files..." button in the "Temporary Internet Files" section.
3) Download and run SQLServer2005_SSMSEE.msi (or SQLServer2005_SSMSEE_x64.msi) from the URL listed above

Either the wrong version of the Management Studio Express CTP download is being used, or the bug hasn't been fixed - as I discovered this morning.

I installed the Management Studio Express and the SQL Books Online. Once the SQL Books Online was installed the Management Studio Express would not start. When I remove the SQL Books Online, the Management Studio Express works just fine.

Could you please check to ensure that the current build of both the Management Studio Express and the Books Online are both the latest builds and let us know when the correct version(s) is available?

Many thanks,

Flavelle|||

I've verified that after installing Management Studio Express CTP from the download site (dated November 11, 2005) and Books Online on a clean machine, Management Studio Express does start.

Only if some version of SQL Server 2005 Management Studio is installed will Management Studio Express not start, and in that event a message box explaining that Management Studio Express cannot run is displayed.

Make sure sqlwb.exe (the full Management Studio's executable) is not installed in your ...\Microsoft SQL Server\90\Tools\binn\vsshell\common7\ide directory. This is what the side-by-side check is looking for.

It is also possible that your web browser has a cached copy of SQLServer2005_SSMSEE.msi from a previous download which it was using. Clearing the browser's download cache might help. If you are using Internet Explorer 6, you can do this by opening IE, clicking on Tools | Options in the menu bar, then clicking the "Delete Files..." button in the "Temporary Internet Files" section. Please let us know if this fixes (or doesn't fix) the problem.

|||HI,

My installation went like this
1) My machine was not a clean install. I have June CTP on it initially. *However*, I used the clean up tool that was provided in the download area to remove any versions of the betas that already existed.
2) installed the sql server express
3) installed the above link for the Management studio

Then I tried a some old sql server script in the management studio to see compatability.

Then I woke up today and said well lets loads books and samples.

Now my Management studio will not load.

What I have done:
1) uninstalled Management Studio
2) installed Management Studio

Did not work

3) did as steven suggested
a)delete files
b)checked the ide directory - NO FILE WAS FOUND

Still did not work

4) Did what the above user stated.
*removed online books

Worked

Any other suggestions? be nice to have books online.

many thanks,

Angela|||Steven:

I verified that sqlwb.exe is not installed - not only in the directory that you suggested, but also anywhere on my machine.

Cleared all temporary files and redownloaded both the Management Studio Express CTP and the SQL Books Online and re-installed both from the new downloads.

With SQL Books Online installed, the Management Studio Express does not work at all. I am not sure what message box you are referring to - I get nothing. Checking Task Manager shows no change in the number of open processes.

The only thing that I can think of is that I did have Visual Studio 2005 Beta 2 installed on my machine, but that was removed long before I started this exercise.

Uninstalled SQL Books online and the Management Studio Express works fine. If I reinstall SQL Books Online, then Management Studio Express does not start - and I do not get any message.

Like Angela said, it would be very nice to be able to run both. Even better would be to have Help integrated with Management Studio Express from SQL Books Online, but at this point, I would happily settle for being able to run both at the same time.

Problem still exists - any more thoughts would be much appreciated.

Thanks,

Flavelle|||I installed
1. Win XP Profi
2. Net Framework 2
3. Net Framework SDK
4. Management Express CTP
(Management Studio Express CTP works ok.)
5. SQL Books Online
(Management Studio Express does not start. No error, no messagebox, no any window.)

I uninstalled SQL Books Online and it works

I have version 2005.90.1399.0 .

Jirka
|||
I uninstalled SQL Books Online and it works too

ssmsee.exe version 9.00.1399.06|||
This is the information from About that is on the SSME that I installed from the link:
Microsoft SQL Server Management Studio Express 9.00.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

The SQL Books online is version 9.00.1399.06

Hope this helps somebody, because this is becoming a Royal Pain. I am coming from an MS Access world and things are sure different in SQL Server.

Regards,

Flavelle|||Well,

I miss spoke. UNinstalling the books did get the Management Studio to come back and run.

*HOwever*, I cna no longer program in the management studio with the query analyzer portion of it. Things that were working before are no longer working...

I ma in the process of using that exe that removes betas to remove the current version of express from my computer.

I will install it yet again *just* the sqlExpress and the management studio. ANd see if that works again. Hopefully, it will..

Is there somewhere online that I can access the books lonline until this problem gets fixed?

I let you know what happened.

Many thanks!

Angela|||Well,

My whole installation is hosed unfortuantely, I am now going to try and REstore to a particular point to get my system back to the way it was.

Otherwise, I will have to spend an entire day rebuilding my system.

Just not good.

The SMSE does not work at all with the query analyzer portion. I can't even create a stored procedure or insert a row into the table.

Hopefully restoring before I put the books on will do the trick.

Let you know :(

Angela|||

When you downloaded the updated Management Studio Express, did you see it take some time to download it again, or did it start immediately? (If it starts immediately, you're running a cached copy of the Windows installer package for SSMSE.)

If you rename the "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell" registry key to "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellX" using regedit, SSMSE should start. This should not affect the stand-alone Books Online at all.

After you rename the registry key and then start Management Studio Express, does the splash Screen say "SQL Server Management Studio Express Edition" or just "Management Studio Express"? The November 11 download says "Management Studio Express."

|||Flavelle, thanks for the version information. That will help investigate this further.

Keep in mind that the Management Studio Express Community Technology Preview is a pre-release product and it isn't "fully baked" - basically it's a daily build from early November. It hasn't had the full stabilization and defect fixing treatment that the full version of SQL Server has gone through. It will be fully stabilized and defects will be fixed before it is released in the first half of 2006.

We made MSE available early to gather feedback from our Express users. Aside from just helping us find defects, we're hoping to gather feedback on how people feel about our MSE design decisions. I'm particularly interested to know how much our decision not to allow MSE to run on the same machine on which people have installed the full Management Studio impacts Express users and whether our decision not to have integrated help in MSE is a big deal to people. (We have user feedback that seems to say people who would use Express tools won't have the full tools on the same machine and that keeping the download size under 30 MB is was really important and people would be willing to give up integrated help if it reduced the download size from 120 MB to 30, which it does.)

I realize this has been pretty frustrating for early adopters, and I apologize for that. I hope there is some consolation in knowing that your feedback now is helping to improve the product when it finally ships in 2006.|||Steven:

Thanks for the information. I would like to remind you of something you said when the thread started:

This update fixes the defect where installing the full Books Online documentation prevented Management Studio Express from starting. With the update, Management Studio Express and Books Online no longer interfere with each other.

On the basis of what is in this thread, I would suggest that might not be the case. Mine is a relatively clean installation - I don't have Visual Studio installed yet, although it is ordered - just waiting for delivery:-)

When I receive Visual Studio, I do plan on installing it. In my case, I do not have a full SQL Server (haven't figured out how to set it up yet - that's a different story). I am a small developer, working on an application. My paying job is a Requirements Engineer and I have been working in development, requirements, and business analysis for more than 20 years. Since I have a little down time, I am going to learn SQL Server. It may kill me, but I will learn it! The SQL Express product is exactly what I need for my application. There are not a lot of managment tools for SQL Express, but the SSME seems to be good enough for my purposes.

It would be nice if it had integrated help, or if it could be hooked into SQL Books Online, and I would be quite happy to have a 120 MB file size. I also have a high-speed internet connection, so the large download is less of an issue for me than it might be for some of your other target users, so I can live without the integrated help.

What is proving very frustrating is that I cannot run both SSME and SQL Books Online. I would be perfectly happy if I could, but I cannot - and that is something that probably shouldn't wait until 2006 to fix, particularly given your statement at the start of the thread.

I am not ranting, just providing what I hope is useful feedback. If there is any more information that I can provide you, please feel free to ask - this is important to me, and I do appreciate your time and support in resolving this issue. In the meantime, please fix the problem as soon as you possibly can, because I am already going through a painful learning curve. I made the interesting discovery about how to replace the MS Access IIF() function, and I am still hoping that someone can tell me how to implement a unique constraint on a field that conforms to ANSI (allows many Null values, but only one instance of each non-Null value).

thanks,

Flavelle|||Steven:

In answer to your specific questions:

1. I downloaded from the site and saved to my local hard drive - if you would like, I will be happy to send the specific files for both SSME and BOL that I received so that you can verify that I am working with the right ones. My e-mail address is fballem@.ballemco.com. If you send me an e-mail, then I will zip and send one or both files to you, whichever would be most helpful to you.

2. I tried renaming the registry entry after installing BOL. When I started BOL, I got an error - sent the report to Microsoft using the standard method. If there is any information that I can provide you that will allow you to find this error, then please let me know. The error occurred at about 5:00 p.m. EST. I renamed the registry entry back to Shell and then uninstalled BOL. SSME works fine.

3. The splash screen is very fast, so I can't read it.

Are you having fun yet?

Regards,

Flavelle|||

Flavelle,

No problem - I appreciate your feedback.

I suspect that your web browser cache or a web proxy cache is interfering with you downloading the November 11 update and you are reinstalling the November 7 release again. You can tell which version you have by checking the creation date of the ssmsee.exe file in ...\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE. If the creation date is November 10, 2005, then you have the update. If the creation date is November 3, then you have the first release.

If you have the first release, you can use regedit to rename the "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell" key to "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellX". This will let the November 7 version of MSE run with Books Online. If MSE still can't start, then we have an unrelated problem I need to investigate further.

The only differences between the November 11 update and the November 7 release are that the November 11 release is supposed to fix the problem with starting MSE when Books Online is installed (without renaming or removing the registry key), the problem of the error message explaining why it isn't starting not appearing, and that the splash screen says "Management Studio Express" rather than "SQL Server Management Studio Express Edition" for the product name.

my sqlsp.log

this is the end of my sqlsp.log after sp3a install to existing SQL 200
11:03:54 Begin: SetupRegistry(
11:03:54 Register this installation of SQL Server with MDA
11:03:54 Completed registering this installation of SQL Server with MDA
11:03:55 Start Process...updating reg entries for S
11:03:55 No Server -> Tool
11:03:55 End: SetupRegistry(
11:03:55 Begin: PostSetupRegistry(
11:03:55 C:\PROGRA~1\COMMON~1\MICROS~1\SQLDEB~1\SQLDBR~1.EXE sqldbreg2.exe -RegServe
11:03:56 End: PostSetupRegistry(
11:04:07 You should now backup your master and msdb databases since this installation has updated their content
11:04:07 Action CleanUpInstall
11:04:09 Installation Completed with Errors (number of nonfatal errors: 1
But when I check @.@.version I am still on sp2. Did not see indication of what the nonfatal error was. Idea what I should be looking for?The last line says: 11:04:09 Installation Completed with
Errors (number of nonfatal errors: 1)
Your SQL SP# installation was not succesfull, please fix
the issue and re-install em
Thank you,
Saleem Hakani
>--Original Message--
>this is the end of my sqlsp.log after sp3a install to
existing SQL 2000
>11:03:54 Begin: SetupRegistry()
>11:03:54 Register this installation of SQL Server with
MDAC
>11:03:54 Completed registering this installation of SQL
Server with MDAC
>11:03:55 Start Process...updating reg entries for SP
>11:03:55 No Server -> Tools
>11:03:55 End: SetupRegistry()
>11:03:55 Begin: PostSetupRegistry()
>11:03:55 C:\PROGRA~1\COMMON~1\MICROS~1\SQLDEB~1
\SQLDBR~1.EXE sqldbreg2.exe -RegServer
>11:03:56 End: PostSetupRegistry()
>11:04:07 You should now backup your master and msdb
databases since this installation has updated their
content.
>11:04:07 Action CleanUpInstall:
>11:04:09 Installation Completed with Errors (number of
nonfatal errors: 1)
>But when I check @.@.version I am still on sp2. Did not
see indication of what the nonfatal error was. Idea what
I should be looking for?
>.
>

my SQL cant open window when installation

Is there anyone can help me to run window when after done with installation, i wana open but i got message" this installation package could not be opened. verify that the package exists and that you can access it. or contact the application vedor to verify that this is a valid Windows Installer package"
My comp is running w/ Win home XP.
thanks

I have installed the Eval Enterprise edition in XP home but I think you can only install personal edition in XP home, so I would check the edition you are installing. Hope this helps.

My program uses a database. Does the end-user have to have SQL server 2005?

My program uses a database. Does the end-user have to have SQL server 2005?

It uses it to keep track of members so the database is in the installation folder and does not need to be accessed remotely

http://i130.photobucket.com/albums/p247/tarkster2/screen.gif

the above shows this error on another persons computer. they do not have sql server.

It depends on your application. If it is a web application, then you only need SQL server for the application itself but the end users don't need. If it is a client server application, it will depend on how the client is implemented. If the client accesses the database directly then you will need a client access license. If only the server does, then you only need 1 SQL Server for the server application.

Read the following articles that discuss the licensing schemes:

http://www.microsoft.com/sql/howtobuy/default.mspx

http://www.microsoft.com/sql/howtobuy/faq.mspx

http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

I'm not sure if I helped but I hope I answered your question. If not, please give more details on how the application is implemented.

Best regards,

Sami Samir

|||

End users do NOT have to have SQL Server -however they MUST have a license to use SQL Server -even if their usage is through a web server. Each user MUST have either a 'Client Access License' (CAL), or if there are many users, it may be less expensive to purchase a Server based 'Processor' license -which allows unlimited users without each user needing a CAL.

However, in your situation, it seems that the user is receiving an error because the remote SQL Server is not allowing remote connections. Remote connections MUST be allowed in order for other user at other computers to access the SQL Server.