Microsoft no longer lets us download SqlServer Express 2005. Does anybody know why? I thought it was free.
http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&DisplayLang=en
In fact, none of the many options here work at all:
http://www.microsoft.com/downloads/browse.aspx?displaylang=en&productID=9F07F9CC-C308-4EBF-A4E9-2B8530AB1EA8
How come? Is there someplace else I can get it? I just don't understand why they do this stuff with no explanation. I'm trying to learn C# and I need a database.
Any help would be appreciated.
Dave
Arlington, Virginia
Did you try from this location:
http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx
|||You should always use the dynamic link of the MS page for bookmarking where possible as it will be changed if the page is moved.The link for SQL Server Express is: http://go.microsoft.com/fwlink/?LinkId=65212
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||
That location didn't work, either. I get this message:
Internet Explorer cannot display the webpage
Most likely causes:
That link didn't work, either. Have you tried to download it? I get this message:
Internet Explorer cannot display the webpage
|||hi,
I tested it now..
I can both download from http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&DisplayLang=en and, sp2, from http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65-e4465cdff1e7&DisplayLang=en
regards
|||Seems to be a problem in your internet connection, maybe you are behind a proxy which does not allow do download exe files ?Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||I think the point is being missed. It's failing to download at all no matter where the OP goes, correct? If that is the case then it may be an IE security setting.|||
Yes, exactly. I have been trying for over two weeks now and still cannot download any product from any category from Microsoft. I always get the "page not found error". I spent one hour with a technichian from my ISP (Comcast) and they made sure there were no issues with their company provided router or names server. They determined that it is definitely something wrong at Microsoft. We also tried lowering all security settings with Explorer and that didn't help either. I am not using a proxy.
Then I actually paid $35 to Microsoft to get help but that person couldn't help me, either, but the trouble ticket is still open. So far, Microsoft hasn't gotten back to me because every email they send me asking how I am doing does not come with a return address so I cannot reply. 
I gues this is the point where I have to reinstall Windows but, geez, what a pain in the neck. God only know what box somewhere on some window has to be checked to fix this. lol. Maybe it is a sign to switch to Vista.
David
|||i just tried all of those links from all of my machines and they all work fine so it's something specific to your machine. i would say that it sounds like a software problem on your internet explorer.
My suggestion would be to hold down left control to bypass any popup blockers or third party software installed into IE that could interact badly with it.
uninstall google/yahoo toolbars (or equivalent programs), weatherbug, etc
try installing firefox.
or
try downgraded from ie7 to 6 or upgrading from ie 6 to 7 (didn't really pay attention to which you're on)
you also might want to run a spybot S&D check or adaware ot clear any bho (browser helper objects) that may be installed into ie)
lastly, be sure you aren't already downloading 2 files when you go to hit download as ie only will download 2 files at a time (i think)
|||I also echo that; I can get to the download page fine and also the download proceeds fine.|||Whew, I still cannot download from Microsoft. So I downloaded Firfefox and got the same issue: page not found.
I also tried the manual link that Microsoft gives should the normal download link fail. That failed, too.
So then I tried cleaning out the hosts file: no luck there either.
Next, I tried flushing the DNS server. Didn't work.
I turned off the firewall, turned off virus checking, and lowered all security settings in IE to the lowest. No luck.
Then I bought Vista and installed it out of desperation. That didn't work either.
Sooooo, now I finally found a page posted by somebody else who uses Comcast, like me, just 3 days ago and it seems to be an issue with the Comcast DNS server. When I get home from work I am going to put in alternate DNS names servers in my network connections instead of the automatic ones. If it works I will tell you.
So far I have spent $550 to try and fix this problem and a total of 11 hours speaking with help desks. 
Davicito
|||I can now tell you that my problem is solved. Turned out it was the DNS server from Comcast. I had to go into Network Connections and manually select the DNS servers by turning off the automatic selection process.
I am using the following instead:
4.2.2.4
4.2.2.5
Now I can download anything from Microsoft plus all my other internet connections are much, much faster, too!
So Comcast is the problem.
I upgraded to Vista for nothing but, actually, now I am glad I did. It's fantastic to use. I bought a video card, too, so that I can use the new Aero look. I am really liking it much better than XP
Davicito
Washington, DC
|||I have to say, I love you.
I've been having the same problem downloading from Microsoft. I've spent countless days and hours trying to figure this out. I also had that same problem with emailing between Microsoft and myself.
Yours is the first solution I've found to the problem, because I also have Comcast.
However, now I'm stuck at, how do you fix it? I don't completely understand how you switched servers and whatnot. A run through would be GREAT.
Thanks so much,
Lyssa
sql
Microsoft No Longer Lets Us Download SqlExpress. Why?
Microsoft no longer lets us download SqlServer Express 2005. Does anybody know why? I thought it was free.
http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&DisplayLang=en
In fact, none of the many options here work at all:
http://www.microsoft.com/downloads/browse.aspx?displaylang=en&productID=9F07F9CC-C308-4EBF-A4E9-2B8530AB1EA8
How come? Is there someplace else I can get it? I just don't understand why they do this stuff with no explanation. I'm trying to learn C# and I need a database.
Any help would be appreciated.
Dave
Arlington, Virginia
Did you try from this location:
http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx
|||You should always use the dynamic link of the MS page for bookmarking where possible as it will be changed if the page is moved.The link for SQL Server Express is: http://go.microsoft.com/fwlink/?LinkId=65212
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||
That location didn't work, either. I get this message:
Internet Explorer cannot display the webpage
Most likely causes:
That link didn't work, either. Have you tried to download it? I get this message:
Internet Explorer cannot display the webpage
|||hi,
I tested it now..
I can both download from http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&DisplayLang=en and, sp2, from http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65-e4465cdff1e7&DisplayLang=en
regards
|||Seems to be a problem in your internet connection, maybe you are behind a proxy which does not allow do download exe files ?Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||I think the point is being missed. It's failing to download at all no matter where the OP goes, correct? If that is the case then it may be an IE security setting.|||
Yes, exactly. I have been trying for over two weeks now and still cannot download any product from any category from Microsoft. I always get the "page not found error". I spent one hour with a technichian from my ISP (Comcast) and they made sure there were no issues with their company provided router or names server. They determined that it is definitely something wrong at Microsoft. We also tried lowering all security settings with Explorer and that didn't help either. I am not using a proxy.
Then I actually paid $35 to Microsoft to get help but that person couldn't help me, either, but the trouble ticket is still open. So far, Microsoft hasn't gotten back to me because every email they send me asking how I am doing does not come with a return address so I cannot reply.
I gues this is the point where I have to reinstall Windows but, geez, what a pain in the neck. God only know what box somewhere on some window has to be checked to fix this. lol. Maybe it is a sign to switch to Vista.
David
|||i just tried all of those links from all of my machines and they all work fine so it's something specific to your machine. i would say that it sounds like a software problem on your internet explorer.
My suggestion would be to hold down left control to bypass any popup blockers or third party software installed into IE that could interact badly with it.
uninstall google/yahoo toolbars (or equivalent programs), weatherbug, etc
try installing firefox.
or
try downgraded from ie7 to 6 or upgrading from ie 6 to 7 (didn't really pay attention to which you're on)
you also might want to run a spybot S&D check or adaware ot clear any bho (browser helper objects) that may be installed into ie)
lastly, be sure you aren't already downloading 2 files when you go to hit download as ie only will download 2 files at a time (i think)
|||I also echo that; I can get to the download page fine and also the download proceeds fine.|||Whew, I still cannot download from Microsoft. So I downloaded Firfefox and got the same issue: page not found.
I also tried the manual link that Microsoft gives should the normal download link fail. That failed, too.
So then I tried cleaning out the hosts file: no luck there either.
Next, I tried flushing the DNS server. Didn't work.
I turned off the firewall, turned off virus checking, and lowered all security settings in IE to the lowest. No luck.
Then I bought Vista and installed it out of desperation. That didn't work either.
Sooooo, now I finally found a page posted by somebody else who uses Comcast, like me, just 3 days ago and it seems to be an issue with the Comcast DNS server. When I get home from work I am going to put in alternate DNS names servers in my network connections instead of the automatic ones. If it works I will tell you.
So far I have spent $550 to try and fix this problem and a total of 11 hours speaking with help desks.
Davicito
|||I can now tell you that my problem is solved. Turned out it was the DNS server from Comcast. I had to go into Network Connections and manually select the DNS servers by turning off the automatic selection process.
I am using the following instead:
4.2.2.4
4.2.2.5
Now I can download anything from Microsoft plus all my other internet connections are much, much faster, too!
So Comcast is the problem.
I upgraded to Vista for nothing but, actually, now I am glad I did. It's fantastic to use. I bought a video card, too, so that I can use the new Aero look. I am really liking it much better than XP
Davicito
Washington, DC
|||I have to say, I love you.
I've been having the same problem downloading from Microsoft. I've spent countless days and hours trying to figure this out. I also had that same problem with emailing between Microsoft and myself.
Yours is the first solution I've found to the problem, because I also have Comcast.
However, now I'm stuck at, how do you fix it? I don't completely understand how you switched servers and whatnot. A run through would be GREAT.
Thanks so much,
Lyssa
Microsoft launches SQL Server 2005.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft launches SQL Server 2005.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft launches SQL Server 2005.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
sql
Microsoft launches SQL Server 2005.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft launches SQL Server 2005.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Wednesday, March 21, 2012
microsoft jdbc driver for SQL Server 7.0
I need a Microsft jdbc driver to connect Microsoft SQL
Server 7.0 . I can find a driver Microsoft 2000 jdbc
driver through which I can access Microsoft SQL Server
2000 but not 7.0.
I do not like to go for a third party driver..
Thank you in advance,
Hanson.
Third party solution is what you will likely have to get. You can pay for one
or just get a free one that works really well:
http://jtds.sourceforge.net/
Good luck.
Yuval
"Hanson" wrote:
> Hi,
> I need a Microsft jdbc driver to connect Microsoft SQL
> Server 7.0 . I can find a driver Microsoft 2000 jdbc
> driver through which I can access Microsoft SQL Server
> 2000 but not 7.0.
> I do not like to go for a third party driver..
> Thank you in advance,
> Hanson.
>
|||"Hanson" <rarockia@.chn.cognizant.com> wrote in message
news:4d7001c4804e$40294f30$a601280a@.phx.gbl...
> Hi,
> I need a Microsft jdbc driver to connect Microsoft SQL
> Server 7.0 . I can find a driver Microsoft 2000 jdbc
> driver through which I can access Microsoft SQL Server
> 2000 but not 7.0.
> I do not like to go for a third party driver..
> Thank you in advance,
> Hanson
The Microsoft JDBC driver was designed specifically for SQL Server 2000. As
was mentioned before, you will have to consider an alternative solution if
you wish to connect to SQL Server 7.0.
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security..
Microsoft Help! SqlServerAgent Won't Start after Reboot
ent in EM' but haven't received any suggestions.
Problem: The SQLServerAgent can be started from DOS Prompt but doesn't start
on reboot and cannot be started from within the Enterprise manager without
error 1060: (The specified service does not exist as an installed service)
occurred while performing t
his service operation on the SQLServerAgent service.
History: Installed Office service pack and it 'messed' up the Enterprise Man
ager. After reinstalling the client tools and the sp3a service pack all wor
ked but scheduled jobs. It turns out that the SQL Server Agent is not runni
ng. It doesn't automatical
ly start up but can be started from DOS whereby my jobs in turn can execute
with no problem.
There used to be an error 8344 SuperSocket Error but after the registers we
re cleaned and errors removed the event error no longer appears. When viewi
ng the registry for SQLServerAgent there was some mention in one of the prev
ious posts about "dependa
ncies" in the registry which is not present. Suspect that the registry is
not complete and would like to know what is missing so that so that SQLServ
erAgent can properly run without manual intervention.
Please advise.
dmatta59
Have posted previously under the subject 'Missing What To Start SQLServer Ag
ent in EM' but haven't received any suggestions.
Problem: The SQLServerAgent can be started from DOS Prompt but doesn't start
on reboot and cannot be started from within the Enterprise manager without
error 1060: (The specified service does not exist as an installed service)
occurred while performing t
his service operation on the SQLServerAgent service.
History: Installed Office service pack and it 'messed' up the Enterprise Man
ager. After reinstalling the client tools and the sp3a service pack all wor
ked but scheduled jobs. It turns out that the SQL Server Agent is not runni
ng. It doesn't automatical
ly start up but can be started from DOS whereby my jobs in turn can execute
with no problem.
There used to be an error 8344 SuperSocket Error but after the registers we
re cleaned and errors removed the event error no longer appears. When viewi
ng the registry for SQLServerAgent there was some mention in one of the prev
ious posts about "dependa
ncies" in the registry which is not present. Suspect that the registry is
not complete and would like to know what is missing so that so that SQLServ
erAgent can properly run without manual intervention.
Please advise.
dmatta59dmatta59,
You could try and install the latest SQL Server service pack. That might fix
it. If not, you may wish to raise a call with MS PSS.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk|||Service pack 3a was installed after the client tools were installed. The on
ly glitch in the installation was that it had to be installed using the sa i
d and password b/c it couldn't verify a valid domain id and password. (I be
lieve related to the SQLSer
verAgent not working somehow). Otherwise installation was successful...|||Have resolved the problem. Used scm.exe to install the SQLServerAgent servi
ce using the instructions on the following article:
http://groups.google.com/groups?q=i...tngxa06&rnum=21
**Please note that the in this case the sqlagent -c -v was working from the
dos prompt and the jobs could run properly. The only problem was that the S
QLServerAgent was not automatically starting or couldn't be started within E
M.
Thank you,
dmatta59|||Status: SQLServerAgent Service Re-Installed
Problem: Missing SQLServerAgent
Symptoms: SQLServerAgent would not automatically start and could not
be started using Enterprise Manager. However, the SQLServerAgent could
be started from a dos command prompt using sqlagent -c -v from the
directory that sqlagent.exe resided.
Used scm.exe to INSTALL the SQLServerAgent service using the
instructions on the following article:
http://groups.google.com/groups?q=i...tngxa06&rnum=21
dmatta59
Mark Allison <marka@.no.tinned.meat.mvps.org> wrote in message news:<FC8661CC-BF2D-492E-93CE
-C73B040F7D17@.microsoft.com>...
> dmatta59,
> You could try and install the latest SQL Server service pack. That might fix it. I
f not, you may wish to raise a call with MS PSS.sql
Microsoft Help! SQLServerAgent Missing Something....
ent in EM' but haven't received any suggestions.
Problem: The SQLServerAgent can be started from DOS Prompt but doesn't start
on reboot and cannot be started from within the Enterprise manager without
error 1060: (The specified service does not exist as an installed service)
occurred while performing t
his service operation on the SQLServerAgent service.
History: Installed Office service pack and it 'messed' up the Enterprise Man
ager. After reinstalling the client tools and the sp3a service pack all wor
ked but scheduled jobs. It turns out that the SQL Server Agent is not runni
ng. It doesn't automatical
ly start up but can be started from DOS whereby my jobs in turn can execute
with no problem.
There used to be an error 8344 SuperSocket Error but after the registers we
re cleaned and errors removed the event error no longer appears. When viewi
ng the registry for SQLServerAgent there was some mention in one of the prev
ious posts about "dependa
ncies" in the registry which is not present. Suspect that the registry is
not complete and would like to know what is missing so that so that SQLServ
erAgent can properly run without manual intervention.
Please advise.
dmatta59Windows Service Dependancies are stored in the "DependOnService" value under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\SQLAgent$[Instance
name]. The value should be "MSSQL$[Instance name]. There is a
"DependOnGroup" value which should be empty as there are no dependant
service groups for SQL Agent.
I'm wondering how you think installing an Office Service Pack could have
anything to do with this SQL Agent's auto startup? I could understand it
mucking up SQL Enterprise Manager, but I'd be amazed if it actually messed
with the Winndows Service Control Manager registry values for services that
have nothing to do with Office..
What did you mean when you said "but after the registers were cleaned.."?
Did you manually alter the registry? I don't mean this to be antagonistic,
but I really suggest you learn to backup the registry before making changes.
Obviously you didn't do this or you wouldn't be asking for what the values
should be. I assure you this is a valuable lesson to learn.
Did you check the Windows Event Log?
Regards,
Greg Linwood
SQL Server MVP
"dmatta59" <anonymous@.discussions.microsoft.com> wrote in message
news:3B363F0E-C782-40A2-8B2F-BB0AB4E14FFF@.microsoft.com...
> Have posted previously under the subject 'Missing What To Start SQLServer
Agent in EM' but haven't received any suggestions.
> Problem: The SQLServerAgent can be started from DOS Prompt but doesn't
start on reboot and cannot be started from within the Enterprise manager
without error 1060: (The specified service does not exist as an installed
service) occurred while performing this service operation on the
SQLServerAgent service.
> History: Installed Office service pack and it 'messed' up the Enterprise
Manager. After reinstalling the client tools and the sp3a service pack all
worked but scheduled jobs. It turns out that the SQL Server Agent is not
running. It doesn't automatically start up but can be started from DOS
whereby my jobs in turn can execute with no problem.
> There used to be an error 8344 SuperSocket Error but after the registers
were cleaned and errors removed the event error no longer appears. When
viewing the registry for SQLServerAgent there was some mention in one of the
previous posts about "dependancies" in the registry which is not present.
Suspect that the registry is not complete and would like to know what is
missing so that so that SQLServerAgent can properly run without manual
intervention.
> Please advise.
> dmatta59
>
>|||1) Regarding Office Service Pack: It didn't dawn on me that an office servi
ce pack would have impacted the SQL Server EM either. However after the se
rvice pack installation, the EM was not accessable and the 'clean up' has be
en given to me.
"Article from MSDN: OSE: Error Messages When You Install Office Server Exten
sions on Computer with SQL Server 2000
http://support.microsoft.com/defaul...kb;en-us;281460"
2) I installed the client tools followed by the service pack 3a. The EM wor
ked great but not the SQLServer agent which in turn meant that the batch job
s would not execute. The message in the event id was 8344 and some of the o
ptions for 'fixing' were ut
ilized but didn't work. Meanwhile, it was determined that the SQLServerAgen
t wasn't automatically starting after reboot or from within EM. However, th
e SQLServerAgent could be manually started from a DOS window and the batch j
obs work fine.
3) The registers were not cleaned manually but with a tool developed by Micr
osoft. A copy of the registers before the clean routine was made and is sti
ll available. An error was detected and corrected. The event id of 8344 d
oesn't happen anymore but t
hen the SQLServerAgent still doesn't start except manually from a dos windo
w....
It seems that common to an automatic startup and to a manual startup within
the EM would be a dll and/or a registry that is corrupt and/or missing, resp
ectively. Any ideas?
Thanxs,
dmatta59|||Greg,
A few more bits of information ......
The Sql database and EM was working fine on the 15th am. Then the service p
ack was installed on the 15th pm. The EM not working was noticed immediatel
y so client tools and 3a service pack were installed -- all was working exce
pt SQLServer Agent which wa
s not detected until a few days later. Viewing the history reveals that th
e 5am download worked fine on the 15th but no other downloads were attempted
after the 15th and no errors were generated. For this reason, I suspect t
hat the office service pack
affected the SQLServer agent ... Maybe it is a coincidence and something el
se 'hit' at the same time but still need to fix the problem of the SQLServer
Agent not starting automatically or from within the EM...
As the registry reference,
Windows Service Dependancies are stored in the "DependOnService" value under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\SQLAgent$[Instance
name]. The value should be "MSSQL$[Instance name]. There is a
"DependOnGroup" value which should be empty as there are no dependant
service groups for SQL Agent.
Here is what I see in the registry for my default named instance is under:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services--SQLAgent
--Enum
--(Default) REG_SZ (value not set)
--0 REG_SZ Root\LEGACY_SQLSERV
ERAGENT\0000
--Count REG_DWORD (1)
--NextInstance REG_DWORD (1)
There is nothing else.
Would appreciate your input...
dmatta59|||Status: SQLServerAgent Service Re-Installed
Problem: Missing SQLServerAgent
Symptoms: SQLServerAgent would not automatically start and could not
be started using Enterprise Manager. However, the SQLServerAgent could
be started from a dos command prompt using sqlagent -c -v from the
directory that sqlagent.exe resided.
Used scm.exe to INSTALL the SQLServerAgent service using the
instructions on the following article:
http://groups.google.com/groups?q=i...tngxa06&rnum=21
dmatta59
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message news:<ucDcvxkFEHA.3880@.TK2MSFTNGP10
.phx.gbl>...
> Windows Service Dependancies are stored in the "DependOnService" value und
er
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\SQLAgent$[Instanc
e
> name]. The value should be "MSSQL$[Instance name]. There is a
> "DependOnGroup" value which should be empty as there are no dependant
> service groups for SQL Agent.
> I'm wondering how you think installing an Office Service Pack could have
> anything to do with this SQL Agent's auto startup? I could understand it
> mucking up SQL Enterprise Manager, but I'd be amazed if it actually messed
> with the Winndows Service Control Manager registry values for services tha
t
> have nothing to do with Office..
> What did you mean when you said "but after the registers were cleaned.."?
> Did you manually alter the registry? I don't mean this to be antagonistic,
> but I really suggest you learn to backup the registry before making change
s.
> Obviously you didn't do this or you wouldn't be asking for what the values
> should be. I assure you this is a valuable lesson to learn.
> Did you check the Windows Event Log?
> Regards,
> Greg Linwood
> SQL Server MVP
> "dmatta59" <anonymous@.discussions.microsoft.com> wrote in message
> news:3B363F0E-C782-40A2-8B2F-BB0AB4E14FFF@.microsoft.com...
> Agent in EM' but haven't received any suggestions.
> start on reboot and cannot be started from within the Enterprise manager
> without error 1060: (The specified service does not exist as an installed
> service) occurred while performing this service operation on the
> SQLServerAgent service.
> Manager. After reinstalling the client tools and the sp3a service pack al
l
> worked but scheduled jobs. It turns out that the SQL Server Agent is not
> running. It doesn't automatically start up but can be started from DOS
> whereby my jobs in turn can execute with no problem.
> were cleaned and errors removed the event error no longer appears. When
> viewing the registry for SQLServerAgent there was some mention in one of t
he
> previous posts about "dependancies" in the registry which is not presen
t.
> Suspect that the registry is not complete and would like to know what is
> missing so that so that SQLServerAgent can properly run without manual
> intervention.
Microsoft Distributed Blank CDs for Sqlserver 2005 and MSDN Library at Launch?
at the SQLServer Launch in Chicago are blank. Has anyone else had this
problem and or requested replacements? If so, how.
thanks much
MoD Kav wrote:
> The SQL SERver 2005 Standard Edidtion install CD and the MSDN CD distributed
> at the SQLServer Launch in Chicago are blank. Has anyone else had this
> problem and or requested replacements? If so, how.
> thanks much
> Mo
Why not send the blank CD's to Microsoft and ask them to replace them?
Monday, March 12, 2012
MIcrosft SQLServer Best Practices document on securing SQLServer
websites that was titled somethign like "MS SQL Server Best Practices"
and detailed a nyumber of best practices about securing the server.
Included in this was revoking public access to the system table
objects.
Can someone post the URL where I can pick this up, or drop me a note on
contacting them for a copy of the document?"byrocat" <bdealhoy@.sympatico.ca> wrote in message
news:1122653744.611069.56230@.o13g2000cwo.googlegro ups.com...
> I'm chasing after a documetn that was available on one of the Microsoft
> websites that was titled somethign like "MS SQL Server Best Practices"
> and detailed a nyumber of best practices about securing the server.
> Included in this was revoking public access to the system table
> objects.
> Can someone post the URL where I can pick this up, or drop me a note on
> contacting them for a copy of the document?
You can find the Microsoft security docs, including a best practices white
paper, here:
http://www.microsoft.com/sql/techin...ty/default.mspx
I don't know of any good reason to revoke public permissions on system
tables - it might actually break something if users can't retrieve metadata
for some operations. Books Online states that a REVOKE applied to the public
role applies to all database users, which is probably not desirable in many
cases.
This issue often seems to be raised by IT auditors, probably because it has
somehow became part of an industry-standard audit checklist, but the MS best
practices document says only "do not grant additional permissions to this
role", implying that the existing permissions are fine:
http://www.microsoft.com/technet/pr...n/sp3sec02.mspx
Simon|||byrocat (bdealhoy@.sympatico.ca) writes:
> I'm chasing after a documetn that was available on one of the Microsoft
> websites that was titled somethign like "MS SQL Server Best Practices"
> and detailed a nyumber of best practices about securing the server.
> Included in this was revoking public access to the system table
> objects.
I would not do this. At least not without extensive testing first.
The fact that all metadata is open to anyone is not entirely
satisfyable, but the opposite is not good either.
In SQL 2005 things are different. Here you can only see metadata
for objects that you have access to. Unfortunately, this important
distinction is not possible to make in SQL 2000.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
Mgt Studio Express vs Mgt Studio "Full" questions
I am currently using Management Studio Express to administer remote SQLServer databases I support as a DBA. I notice that I cannot "see" DTS packages on the remote server from Express, but when I login directly to the server (Term Services) and use the local Management Studio (Full?), that I CAN see the DTS packages.
1) What are the other differences between Management Studio Express and Management Studio "Full"?
2) Is it possible to aquire and install (upgrade) on my workstation, to Management Studio "Full" so that I can take advantage of the additional capabilities the "Express" version does not have, in order to manage my remote servers?
TIA,
Phil Streiff, MCDBA
There are quite a few differences between SSMS and SSMS-Express.
You can obtain (and be properly licensed for) SSMS with SQL Server Workgroup, Standard and Enterprise Edition.
|||Thanks Arnie,
I will definitely upgrade to SSMS now, based on your input.
I suppose I have to pay for the SQL2K5 Standard or Workgroup license, even though I'm only installing the Mgt Studio on my workstation and not the whole database engine.
Phil
|||SS 2005 Workgroup Edition is about $750 with 5 CALs. (Maybe better pricing is around.)
IF you were in a dev environment, you could get SS Developer's Edition for about $50. But I don't think that it would be legit to manage production servers.
Maybe one or more of your clients provide you with SSMS to manage their servers.
For definitive licensing questions, call the licensing folks at:
Licensing –VL Contact
(800) 426-9400
Good Luck!
Friday, March 9, 2012
method of encrypting the pass of IP, PASS, USER to the SQL ?
server without using VPN ?
Thanks
Scott
Are you talking about encrypting it on the wire? Or storing it in a
databases?
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"scott" <nospamscott@.yahoo.com> wrote in message
news:uSK0EDblEHA.2948@.TK2MSFTNGP11.phx.gbl...
> Is there a method of encrypting the passing of IP, PASS, USER to the SQL
> server without using VPN ?
> Thanks
> Scott
>
|||"scott" <nospamscott@.yahoo.com> wrote in message
news:uSK0EDblEHA.2948@.TK2MSFTNGP11.phx.gbl...
> Is there a method of encrypting the passing of IP, PASS, USER to the SQL
> server without using VPN ?
In my experience and based on a few minute's sniffing, the login id and
client hostname always appear in clear text whatever the connection method.
For DB-Library SQL Server authenticated logins, the password is always clear
text.
For ADO SQL Server authenticated logins, the password is encrypted.
For Windows authentication (aka trusted authentication), passwords are not
passed with the TDS login packet: they are already passed encrypted at an
earlier stage.
Kind Regards, Howard
Saturday, February 25, 2012
Messages back from SqlServer while a Backup is being completed?
database. In order to back up the database I am using the BACKUP DATABASE
t-sql and the STATS=5 in order to get the progress back from sql server.
Here is the exact script:
BACKUP DATABASE test_dvpt
TO test_Backup
WITH INIT,
STATS=5
Does anyone know how I can get the messages like "5 percent backed up" ...
"10 percent backed up" to my win forms application in order to update a
progress bar?You can handle the connection object InfoMessage event to get these progress
messages.
Hope this helps.
Dan Guzman
SQL Server MVP
"Jason Haley" <JasonHaley@.discussions.microsoft.com> wrote in message
news:3D7A28DB-F43E-4A3E-8909-14363404A177@.microsoft.com...
>I have a WinForms application in which I am wrapping the backing up of a
>sql
> database. In order to back up the database I am using the BACKUP DATABASE
> t-sql and the STATS=5 in order to get the progress back from sql server.
> Here is the exact script:
> BACKUP DATABASE test_dvpt
> TO test_Backup
> WITH INIT,
> STATS=5
> Does anyone know how I can get the messages like "5 percent backed up" ...
> "10 percent backed up" to my win forms application in order to update a
> progress bar?