I too am having problems with MSDE with VS.NET. I am trying to install the Dunwamish Enterprise Example App and I keep getting the following error: "[DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied." Also, most of the exa
mples refer to the PUBS database which I can't find anywhere. Did it not come wrapped up in MSDE?
I have W2K Pro, Visual Studio .NET 2003, MSDE loaded v8.00.760. Is there anybody out there that can help a .NET newbie out. The guy the company had hired to come in here and start our .NET efforts has quit and dumped all this in my lap. I am familiar with
Visual Studio 6; however, we hav always used Sybase Anywhere before. Any help will be appreciated.
Kenneth A. Jinks, Jr.
Lead Project Software Engineer
LabCorp CPG - LCM Development
Huntsville, AL
> examples refer to the PUBS database which I can't find anywhere.
http://www.microsoft.com/sql/downloads/default.asp#code
http://tinyurl.com/2oyvh
Maybe you didn't permit network access, set a sa-password, didn't disable
antivirus or anything like that?
Regards,
Lars-Inge Tnnessen
www.larsinge.com
Showing posts with label install. Show all posts
Showing posts with label install. Show all posts
Wednesday, March 28, 2012
More installation issues.
Hey everyone, I just downloaded the express edition and tried to install it. I passed all the sys reqs and it seemed to be going well, but it said that "An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'." The full installation log is below.
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Sat Feb 11 09:28:51 2006
Machine : DAN1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_DAN1_SQLSupport_1.log
--
Machine : DAN1
Product : SQL Native Client
Error : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
--
Machine : DAN1
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_DAN1_SQLNCLI_1.log
Last Action : InstallFinalize
Error String : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
Error Number : 1706
--
Machine : DAN1
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_DAN1_SqlWriter_1.log
--
Machine : DAN1
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_DAN1_MSXML6_1.log
--
Machine : DAN1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_DAN1_SQLSupport_2.log
--
Hey Dan. See the following KB article:
http://support.microsoft.com/kb/910229/en-us
See the bullet point numbered 2.1 - "Existing SQL Native Client Installation May Cause Setup to Fail". My guess is that you have a pre-existing SNAC installation and just need to remove it.
HTH,
|||Thanks Chad, that was the problem, I must have missed it when I removed the rest of the beta items.
-Dan.
sqlMore info on SQL Server 2005 Express problem install
When I run the setup there is a System Configuration Check page. I get 13
successes and 2 warnings. The 2 warnings are:
Minimum hardware requirement - there is about 37GB free space, 512MB memory,
an Intel Pentium 4 2.4GHz CPU.
IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
some features may be disabled - that's all.
Then after going through wizard it complained that the SQL Server native
client wasn't available - so ~I will try to download and install that
separately.
Then I get error SQL Server database Services - setup failed. Refer to
setup log - where is that?
There are lots of log files in c:\Program Files\Microsoft SQL Server
subdirectories.
Help please. This is proving a lot harder than I imagined.
AngusI was installing SQL Server 2005 Express Advanced and gave up on that and
installed just standard SQL Server 2005 Express - that worked without a
hitch.
"Angus" <nospam@.gmail.com> wrote in message
news:#mrYry7kHHA.680@.TK2MSFTNGP06.phx.gbl...
> When I run the setup there is a System Configuration Check page. I get 13
> successes and 2 warnings. The 2 warnings are:
> Minimum hardware requirement - there is about 37GB free space, 512MB
memory,
> an Intel Pentium 4 2.4GHz CPU.
> IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
> some features may be disabled - that's all.
> Then after going through wizard it complained that the SQL Server native
> client wasn't available - so ~I will try to download and install that
> separately.
> Then I get error SQL Server database Services - setup failed. Refer to
> setup log - where is that?
> There are lots of log files in c:\Program Files\Microsoft SQL Server
> subdirectories.
> Help please. This is proving a lot harder than I imagined.
> Angus
>
>|||Hi Angus
"Angus" wrote:
> I was installing SQL Server 2005 Express Advanced and gave up on that and
> installed just standard SQL Server 2005 Express - that worked without a
> hitch.
>
The differences are shown at
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx if you
wanted reporting services then you would need advanced edition and IIS, but
it should not stop the install of the other components. I am wondering if you
installed the toolkit by mistake?
John
successes and 2 warnings. The 2 warnings are:
Minimum hardware requirement - there is about 37GB free space, 512MB memory,
an Intel Pentium 4 2.4GHz CPU.
IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
some features may be disabled - that's all.
Then after going through wizard it complained that the SQL Server native
client wasn't available - so ~I will try to download and install that
separately.
Then I get error SQL Server database Services - setup failed. Refer to
setup log - where is that?
There are lots of log files in c:\Program Files\Microsoft SQL Server
subdirectories.
Help please. This is proving a lot harder than I imagined.
AngusI was installing SQL Server 2005 Express Advanced and gave up on that and
installed just standard SQL Server 2005 Express - that worked without a
hitch.
"Angus" <nospam@.gmail.com> wrote in message
news:#mrYry7kHHA.680@.TK2MSFTNGP06.phx.gbl...
> When I run the setup there is a System Configuration Check page. I get 13
> successes and 2 warnings. The 2 warnings are:
> Minimum hardware requirement - there is about 37GB free space, 512MB
memory,
> an Intel Pentium 4 2.4GHz CPU.
> IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
> some features may be disabled - that's all.
> Then after going through wizard it complained that the SQL Server native
> client wasn't available - so ~I will try to download and install that
> separately.
> Then I get error SQL Server database Services - setup failed. Refer to
> setup log - where is that?
> There are lots of log files in c:\Program Files\Microsoft SQL Server
> subdirectories.
> Help please. This is proving a lot harder than I imagined.
> Angus
>
>|||Hi Angus
"Angus" wrote:
> I was installing SQL Server 2005 Express Advanced and gave up on that and
> installed just standard SQL Server 2005 Express - that worked without a
> hitch.
>
The differences are shown at
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx if you
wanted reporting services then you would need advanced edition and IIS, but
it should not stop the install of the other components. I am wondering if you
installed the toolkit by mistake?
John
More info on SQL Server 2005 Express problem install
When I run the setup there is a System Configuration Check page. I get 13
successes and 2 warnings. The 2 warnings are:
Minimum hardware requirement - there is about 37GB free space, 512MB memory,
an Intel Pentium 4 2.4GHz CPU.
IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
some features may be disabled - that's all.
Then after going through wizard it complained that the SQL Server native
client wasn't available - so ~I will try to download and install that
separately.
Then I get error SQL Server database Services - setup failed. Refer to
setup log - where is that?
There are lots of log files in c:\Program Files\Microsoft SQL Server
subdirectories.
Help please. This is proving a lot harder than I imagined.
AngusI was installing SQL Server 2005 Express Advanced and gave up on that and
installed just standard SQL Server 2005 Express - that worked without a
hitch.
"Angus" <nospam@.gmail.com> wrote in message
news:#mrYry7kHHA.680@.TK2MSFTNGP06.phx.gbl...
> When I run the setup there is a System Configuration Check page. I get 13
> successes and 2 warnings. The 2 warnings are:
> Minimum hardware requirement - there is about 37GB free space, 512MB
memory,
> an Intel Pentium 4 2.4GHz CPU.
> IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
> some features may be disabled - that's all.
> Then after going through wizard it complained that the SQL Server native
> client wasn't available - so ~I will try to download and install that
> separately.
> Then I get error SQL Server database Services - setup failed. Refer to
> setup log - where is that?
> There are lots of log files in c:\Program Files\Microsoft SQL Server
> subdirectories.
> Help please. This is proving a lot harder than I imagined.
> Angus
>
>|||Hi Angus
"Angus" wrote:
> I was installing SQL Server 2005 Express Advanced and gave up on that and
> installed just standard SQL Server 2005 Express - that worked without a
> hitch.
>
The differences are shown at
http://msdn.microsoft.com/vstudio/e...re/default.aspx if you
wanted reporting services then you would need advanced edition and IIS, but
it should not stop the install of the other components. I am wondering if yo
u
installed the toolkit by mistake?
John
successes and 2 warnings. The 2 warnings are:
Minimum hardware requirement - there is about 37GB free space, 512MB memory,
an Intel Pentium 4 2.4GHz CPU.
IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
some features may be disabled - that's all.
Then after going through wizard it complained that the SQL Server native
client wasn't available - so ~I will try to download and install that
separately.
Then I get error SQL Server database Services - setup failed. Refer to
setup log - where is that?
There are lots of log files in c:\Program Files\Microsoft SQL Server
subdirectories.
Help please. This is proving a lot harder than I imagined.
AngusI was installing SQL Server 2005 Express Advanced and gave up on that and
installed just standard SQL Server 2005 Express - that worked without a
hitch.
"Angus" <nospam@.gmail.com> wrote in message
news:#mrYry7kHHA.680@.TK2MSFTNGP06.phx.gbl...
> When I run the setup there is a System Configuration Check page. I get 13
> successes and 2 warnings. The 2 warnings are:
> Minimum hardware requirement - there is about 37GB free space, 512MB
memory,
> an Intel Pentium 4 2.4GHz CPU.
> IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
> some features may be disabled - that's all.
> Then after going through wizard it complained that the SQL Server native
> client wasn't available - so ~I will try to download and install that
> separately.
> Then I get error SQL Server database Services - setup failed. Refer to
> setup log - where is that?
> There are lots of log files in c:\Program Files\Microsoft SQL Server
> subdirectories.
> Help please. This is proving a lot harder than I imagined.
> Angus
>
>|||Hi Angus
"Angus" wrote:
> I was installing SQL Server 2005 Express Advanced and gave up on that and
> installed just standard SQL Server 2005 Express - that worked without a
> hitch.
>
The differences are shown at
http://msdn.microsoft.com/vstudio/e...re/default.aspx if you
wanted reporting services then you would need advanced edition and IIS, but
it should not stop the install of the other components. I am wondering if yo
u
installed the toolkit by mistake?
John
Monday, February 20, 2012
MOM 2005 Reporting
I'm trying to install the Mom Reporting service, My MOM 2005 (W2k3 w/sp1)
server also hosts the sql database (sql2000 w/sp3). While running the
install for the reporting services I get this error.
Failed to create data source for data warehouse, check to make sure you can
access the SQL services reporting server. (This is also hosted locally on
the mom server). Error code 2147467259.
Any one have any clues? I am NOT installing the report services to the same
folder as the mom2005 folder per microsoft. Any suggestions or guidance is
greatly appreciated.
Vid
--== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==--
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
--= East and West-Coast Server Farms - Total Privacy via Encryption =--Check your system requirements! 2003 SP1 is not mentioned, only 2003 RTM.
I had to:
1. uninstall SP1.
2. uninstall MOM web console
3. uninstall SRS
4. uninstall Application Services (IIS, ASP, etc.)
5. reinstall Application Services
6. reinstall MOM web console
7. reinstall SRS
8. reinstall MOM reporting services
Early indications are that this seems to have corrected the problem. Your
mileage may vary.
"dave@.xrxdc.com" wrote:
> I'm trying to install the Mom Reporting service, My MOM 2005 (W2k3 w/sp1)
> server also hosts the sql database (sql2000 w/sp3). While running the
> install for the reporting services I get this error.
> Failed to create data source for data warehouse, check to make sure you can
> access the SQL services reporting server. (This is also hosted locally on
> the mom server). Error code 2147467259.
> Any one have any clues? I am NOT installing the report services to the same
> folder as the mom2005 folder per microsoft. Any suggestions or guidance is
> greatly appreciated.
> Vid
> --== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==--
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
> --= East and West-Coast Server Farms - Total Privacy via Encryption =--
>|||Were you able to successfully install the MOM database itself? MOM is rather
picky when it comes to the order in which things are installed...
(1) Install MOM database after installing SQL 2000 w/SP3a
(2) Install MOM application
(3) Install SQL Reporting
As with previous reply - your mileage will vary.
"JerryW" wrote:
> Check your system requirements! 2003 SP1 is not mentioned, only 2003 RTM.
> I had to:
> 1. uninstall SP1.
> 2. uninstall MOM web console
> 3. uninstall SRS
> 4. uninstall Application Services (IIS, ASP, etc.)
> 5. reinstall Application Services
> 6. reinstall MOM web console
> 7. reinstall SRS
> 8. reinstall MOM reporting services
> Early indications are that this seems to have corrected the problem. Your
> mileage may vary.
>
> --
> "dave@.xrxdc.com" wrote:
> > I'm trying to install the Mom Reporting service, My MOM 2005 (W2k3 w/sp1)
> > server also hosts the sql database (sql2000 w/sp3). While running the
> > install for the reporting services I get this error.
> > Failed to create data source for data warehouse, check to make sure you can
> > access the SQL services reporting server. (This is also hosted locally on
> > the mom server). Error code 2147467259.
> >
> > Any one have any clues? I am NOT installing the report services to the same
> > folder as the mom2005 folder per microsoft. Any suggestions or guidance is
> > greatly appreciated.
> >
> > Vid
> >
> > --== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==--
> > http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
> > --= East and West-Coast Server Farms - Total Privacy via Encryption =--
> >
server also hosts the sql database (sql2000 w/sp3). While running the
install for the reporting services I get this error.
Failed to create data source for data warehouse, check to make sure you can
access the SQL services reporting server. (This is also hosted locally on
the mom server). Error code 2147467259.
Any one have any clues? I am NOT installing the report services to the same
folder as the mom2005 folder per microsoft. Any suggestions or guidance is
greatly appreciated.
Vid
--== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==--
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
--= East and West-Coast Server Farms - Total Privacy via Encryption =--Check your system requirements! 2003 SP1 is not mentioned, only 2003 RTM.
I had to:
1. uninstall SP1.
2. uninstall MOM web console
3. uninstall SRS
4. uninstall Application Services (IIS, ASP, etc.)
5. reinstall Application Services
6. reinstall MOM web console
7. reinstall SRS
8. reinstall MOM reporting services
Early indications are that this seems to have corrected the problem. Your
mileage may vary.
"dave@.xrxdc.com" wrote:
> I'm trying to install the Mom Reporting service, My MOM 2005 (W2k3 w/sp1)
> server also hosts the sql database (sql2000 w/sp3). While running the
> install for the reporting services I get this error.
> Failed to create data source for data warehouse, check to make sure you can
> access the SQL services reporting server. (This is also hosted locally on
> the mom server). Error code 2147467259.
> Any one have any clues? I am NOT installing the report services to the same
> folder as the mom2005 folder per microsoft. Any suggestions or guidance is
> greatly appreciated.
> Vid
> --== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==--
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
> --= East and West-Coast Server Farms - Total Privacy via Encryption =--
>|||Were you able to successfully install the MOM database itself? MOM is rather
picky when it comes to the order in which things are installed...
(1) Install MOM database after installing SQL 2000 w/SP3a
(2) Install MOM application
(3) Install SQL Reporting
As with previous reply - your mileage will vary.
"JerryW" wrote:
> Check your system requirements! 2003 SP1 is not mentioned, only 2003 RTM.
> I had to:
> 1. uninstall SP1.
> 2. uninstall MOM web console
> 3. uninstall SRS
> 4. uninstall Application Services (IIS, ASP, etc.)
> 5. reinstall Application Services
> 6. reinstall MOM web console
> 7. reinstall SRS
> 8. reinstall MOM reporting services
> Early indications are that this seems to have corrected the problem. Your
> mileage may vary.
>
> --
> "dave@.xrxdc.com" wrote:
> > I'm trying to install the Mom Reporting service, My MOM 2005 (W2k3 w/sp1)
> > server also hosts the sql database (sql2000 w/sp3). While running the
> > install for the reporting services I get this error.
> > Failed to create data source for data warehouse, check to make sure you can
> > access the SQL services reporting server. (This is also hosted locally on
> > the mom server). Error code 2147467259.
> >
> > Any one have any clues? I am NOT installing the report services to the same
> > folder as the mom2005 folder per microsoft. Any suggestions or guidance is
> > greatly appreciated.
> >
> > Vid
> >
> > --== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==--
> > http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
> > --= East and West-Coast Server Farms - Total Privacy via Encryption =--
> >
Subscribe to:
Posts (Atom)