Frustrating: Can't get to Provider Options in SQL 2005 Express?

Hi,
I'm trying to get to the provider options screen in SQL2K5 Management
Studio, however I am unable to find it anywhere. This is really
frustrating... Here is what I am trying to do:
1.. In SQL Mgmt Studio, connect to the SQL Server Database Engine and go
to Server Objects->Linked Server->Providers in the Object Explorer.
2.. Right-click on a provider and select Properties.
However, all I can see when I right-click is "Refresh" ... How can I access
the provider options? Is this a limitation of the Express database? Is there
a stored proc I can use?
Thanks,
MichaelWhat are you trying to achieve?
Look at the sp_addlinkedserver system procedure.
"Thou shall lear to type. Clicking is the work of the Devil."
-- undisclosed apostle
;)
ML
http://milambda.blogspot.com/|||Thanks, but I have already used sp_addlinkedserver.
I am trying to set the "allow inprocess" provider options... according to
research in the NG's and BOL (see "Linked Server Properties (Provider
Options Page)"), this is set from a dialog that I am unable to access. I
can't see it when adding a new linked server, editing an existing one, or
right-clicking on the provider in Management Studio.
Any ideas?
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:99625079-C5D6-430C-89AB-8AD8421A2731@.microsoft.com...
> What are you trying to achieve?
> Look at the sp_addlinkedserver system procedure.
> "Thou shall lear to type. Clicking is the work of the Devil."
> -- undisclosed apostle
> ;)
>
> ML
> --
> http://milambda.blogspot.com/sql

Frustrating: Can't get to Provider Options in SQL 2005 Express?

Hi,
I'm trying to get to the provider options screen in SQL2K5 Management
Studio, however I am unable to find it anywhere. This is really
frustrating... Here is what I am trying to do:
1.. In SQL Mgmt Studio, connect to the SQL Server Database Engine and go
to Server Objects->Linked Server->Providers in the Object Explorer.
2.. Right-click on a provider and select Properties.
However, all I can see when I right-click is "Refresh" ... How can I access
the provider options? Is this a limitation of the Express database? Is there
a stored proc I can use?
Thanks,
MichaelWhat are you trying to achieve?
Look at the sp_addlinkedserver system procedure.
"Thou shall lear to type. Clicking is the work of the Devil."
-- undisclosed apostle
;)
ML
--
http://milambda.blogspot.com/|||Thanks, but I have already used sp_addlinkedserver.
I am trying to set the "allow inprocess" provider options... according to
research in the NG's and BOL (see "Linked Server Properties (Provider
Options Page)"), this is set from a dialog that I am unable to access. I
can't see it when adding a new linked server, editing an existing one, or
right-clicking on the provider in Management Studio.
Any ideas?
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:99625079-C5D6-430C-89AB-8AD8421A2731@.microsoft.com...
> What are you trying to achieve?
> Look at the sp_addlinkedserver system procedure.
> "Thou shall lear to type. Clicking is the work of the Devil."
> -- undisclosed apostle
> ;)
>
> ML
> --
> http://milambda.blogspot.com/|||Try setting the rest of provider settings through the @.provstr parameter of
the sp_addlinkedserver.
Some examples are available in Books Online.
ML
--
http://milambda.blogspot.com/|||Thanks. After doing some more research, I now know that this is a limitation
of SQL Server Express.
I was however able to use the following system stored procedure to change
the provider options:
EXEC master.dbo.sp_MSset_oledb_prop N'ProviderName', N'AllowInProcess', 1
I hope this can help someone else.
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:1CF1915F-6D1B-443F-B674-7C51B3139B79@.microsoft.com...
> Try setting the rest of provider settings through the @.provstr parameter
> of
> the sp_addlinkedserver.
> Some examples are available in Books Online.
>
> ML
> --
> http://milambda.blogspot.com/|||This is very helpful and good to know. Do you have a blog? Where have you
found the solution?
ML
--
http://milambda.blogspot.com/|||Hi,
Cindy Winegarden answered in microsoft.public.sqlserver.programming, when I
asked for the same problem (25/05/2006)
--
Michel Lévy
Communauté Francophone des Professionnels FoxPro
Pour un développement durable...
http://www.atoutfox.org
--
"ML" <ML@.discussions.microsoft.com> a écrit dans le message de news:
0BAB0C0C-0151-462E-94B0-9686347E430D@.microsoft.com...
> This is very helpful and good to know. Do you have a blog? Where have you
> found the solution?
>
> ML
> --
> http://milambda.blogspot.com/

Frustrating: Can't get to Provider Options in SQL 2005 Express?

What are you trying to achieve?
Look at the sp_addlinkedserver system procedure.
"Thou shall lear to type. Clicking is the work of the Devil."
-- undisclosed apostle
;)
ML
http://milambda.blogspot.com/Thanks, but I have already used sp_addlinkedserver.
I am trying to set the "allow inprocess" provider options... according to
research in the NG's and BOL (see "Linked Server Properties (Provider
Options Page)"), this is set from a dialog that I am unable to access. I
can't see it when adding a new linked server, editing an existing one, or
right-clicking on the provider in Management Studio.
Any ideas?
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:99625079-C5D6-430C-89AB-8AD8421A2731@.microsoft.com...
> What are you trying to achieve?
> Look at the sp_addlinkedserver system procedure.
> "Thou shall lear to type. Clicking is the work of the Devil."
> -- undisclosed apostle
> ;)
>
> ML
> --
> http://milambda.blogspot.com/|||Hi,
I'm trying to get to the provider options screen in SQL2K5 Management
Studio, however I am unable to find it anywhere. This is really
frustrating... Here is what I am trying to do:
1.. In SQL Mgmt Studio, connect to the SQL Server Database Engine and go
to Server Objects->Linked Server->Providers in the Object Explorer.
2.. Right-click on a provider and select Properties.
However, all I can see when I right-click is "Refresh" ... How can I access
the provider options? Is this a limitation of the Express database? Is there
a stored proc I can use?
Thanks,
Michael|||What are you trying to achieve?
Look at the sp_addlinkedserver system procedure.
"Thou shall lear to type. Clicking is the work of the Devil."
-- undisclosed apostle
;)
ML
http://milambda.blogspot.com/|||Thanks, but I have already used sp_addlinkedserver.
I am trying to set the "allow inprocess" provider options... according to
research in the NG's and BOL (see "Linked Server Properties (Provider
Options Page)"), this is set from a dialog that I am unable to access. I
can't see it when adding a new linked server, editing an existing one, or
right-clicking on the provider in Management Studio.
Any ideas?
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:99625079-C5D6-430C-89AB-8AD8421A2731@.microsoft.com...
> What are you trying to achieve?
> Look at the sp_addlinkedserver system procedure.
> "Thou shall lear to type. Clicking is the work of the Devil."
> -- undisclosed apostle
> ;)
>
> ML
> --
> http://milambda.blogspot.com/

Frustrating: Can't get to Provider Options in SQL 2005 Express

Try setting the rest of provider settings through the @.provstr parameter of
the sp_addlinkedserver.
Some examples are available in Books Online.
ML
http://milambda.blogspot.com/Thanks. After doing some more research, I now know that this is a limitation
of SQL Server Express.
I was however able to use the following system stored procedure to change
the provider options:
EXEC master.dbo.sp_MSset_oledb_prop N'ProviderName', N'AllowInProcess', 1
I hope this can help someone else.
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:1CF1915F-6D1B-443F-B674-7C51B3139B79@.microsoft.com...
> Try setting the rest of provider settings through the @.provstr parameter
> of
> the sp_addlinkedserver.
> Some examples are available in Books Online.
>
> ML
> --
> http://milambda.blogspot.com/|||This is very helpful and good to know. Do you have a blog? Where have you
found the solution?
ML
http://milambda.blogspot.com/|||Hi,
Cindy Winegarden answered in microsoft.public.sqlserver.programming, when I
asked for the same problem (25/05/2006)
Michel Lvy
Communaut Francophone des Professionnels FoxPro
Pour un dveloppement durable...
http://www.atoutfox.org
--
"ML" <ML@.discussions.microsoft.com> a crit dans le message de news:
0BAB0C0C-0151-462E-94B0-9686347E430D@.microsoft.com...
> This is very helpful and good to know. Do you have a blog? Where have you
> found the solution?
>
> ML
> --
> http://milambda.blogspot.com/

From SQL Express to XML file

HI guys,

Is there any tool to import the database from SQLExpress to change it into XML without doing much programming code in .Net?

Thanks!

Chin

Hi Chin,

The short answer is no, SQL Express doesn't include any import/export tools. That said, Transact-SQL provides syntax that lets you represent your data as XML, and you could use that to produce XML and then save that to a file.

Check out my answer to a similar question at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368472&SiteID=1 for links to pertinent BOL topics.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

From SQL Express to XML file

HI guys,

Is there any tool to import the database from SQLExpress to change it into XML without doing much programming code in .Net?

Thanks!

Chin

Hi Chin,

The short answer is no, SQL Express doesn't include any import/export tools. That said, Transact-SQL provides syntax that lets you represent your data as XML, and you could use that to produce XML and then save that to a file.

Check out my answer to a similar question at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368472&SiteID=1 for links to pertinent BOL topics.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

sql

from Express to 2005? - How to?

I have a database on SQL 2005 Express and i want to restore in SQL Server 2005 Beta 2 but it's not accepting it? so how can i do it please? any tool?I assume you want to go from the RTM build of Express 9.00.1399 to the Beta build of SQL2K5. If that's the case you cannot do that. Some where between Beta 2 and RTM (I think it was around the March 2005 CTP) the format of the database changed. We supported moving forward but not going backward. I'm not aware of any tools that will allow you to go backward.|||..and in addition to that the license of beta is no longer valid since the RTM was published. if you want to move forward get a RTM version of developer or any version you want to migrate to.

HTH, Jens Suessmeyer.

http://www.sqlsevrer2005.de

|||design an SSIS package to export the database

From databasediagram to T-SQL

Hello, i have made a diagram in a SQL Express database.
i would like to know how to get this to T-SQL CREATE TABLE script?
I don't think you can use SQL Express to do it but we are still in beta so use the link below and download the developer edition to do it. How you use the OLTP(online transaction processing) management studio it is like your Enterprise manager in SQL Server 2000. Hope this helps.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx#EBAA|||

Thanks i understand. I think this is a pretty imporant feature. Because if i have made a Table Diagram in VWD and would like to show it to a friend, i want to be able to convert this diagram to a SQL CREATE TABLE txt script. so my friend can just copy this SQL txt script into his VWD and show up exactly the same tables.

|||Hello, i noticed that i actually can get this diagram to a T-SQL CREATE TABLE script, by clicking on the "Generate change script", but this "menubutton" is only available if i made a change to the database, and because of this i cannot just generate the script when i want to, i have to make changes to the database to do it, i think this is a unnecessary step, this "menubutton" "generate change script" should be available all the time, and it should be renamed to "generate script" so i can generate the T-SQL script whenever i want to.|||Try the post below and test drive the latest CTP, it may be different. Hope this helps.
http://forums.asp.net/1052509/ShowPost.aspx

Fresh installation and no access

I've just installed MS SQL Server Express Advanced Editon and when loggin in
with my user account(using Widnows Vista) I have no permission at all. I
cant create a new database and I cant change any settings. Then I tried
logging on with the sa account. Then I got this error message:
TITLE: Connect to Server
--
Cannot connect to KULVIS\SQLEXPRESS.
ADDITIONAL INFORMATION:
Login failed for user 'sa'. The user is not associated with a trusted SQL
Server connection. (Microsoft SQL Server, Error: 18452)
For help, click:
http://go.microsoft.com/fwlink?Prod...52&LinkId=20476
BUTTONS:
OK
--
StigStig
During the instalation process, did you set up SQL Server to Windows only
or Mixed Authentication?
I don't have Windows Vista to test the problem, sorry.
"Stig Kulvedrsten" <stig@.spire.as> wrote in message
news:EE6F52D2-732E-4A27-8285-3B613E1AA262@.microsoft.com...
> I've just installed MS SQL Server Express Advanced Editon and when loggin
> in with my user account(using Widnows Vista) I have no permission at all.
> I cant create a new database and I cant change any settings. Then I tried
> logging on with the sa account. Then I got this error message:
> TITLE: Connect to Server
> --
> Cannot connect to KULVIS\SQLEXPRESS.
> --
> ADDITIONAL INFORMATION:
> Login failed for user 'sa'. The user is not associated with a trusted SQL
> Server connection. (Microsoft SQL Server, Error: 18452)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...52&LinkId=20476
> --
> BUTTONS:
> OK
> --
> Stig|||I thought I set it to Mixed Authentication but now I'm not sure. Is there
any way to change this setting without reinstalling it?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eGrlvS%23MHHA.4928@.TK2MSFTNGP06.phx.gbl...
> Stig
> During the instalation process, did you set up SQL Server to Windows
> only or Mixed Authentication?
> I don't have Windows Vista to test the problem, sorry.
>
>
> "Stig Kulvedrsten" <stig@.spire.as> wrote in message
> news:EE6F52D2-732E-4A27-8285-3B613E1AA262@.microsoft.com...
>|||Sure
SELECT SERVERPROPERTY('IsIntegratedSecurityOnly
') AS
[IsIntegratedSecurityOnly]
"Stig Kulvedrsten" <stig@.spire.as> wrote in message
news:D25D73BE-1B57-4A7D-9509-52E48E9322C7@.microsoft.com...
>I thought I set it to Mixed Authentication but now I'm not sure. Is there
>any way to change this setting without reinstalling it?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eGrlvS%23MHHA.4928@.TK2MSFTNGP06.phx.gbl...
>|||ok. i ran the query and got 1 as a result.
but how can I change this setting if I dont have any permission?
Stig
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uo6brH$MHHA.1240@.TK2MSFTNGP03.phx.gbl...
> Sure
> SELECT SERVERPROPERTY('IsIntegratedSecurityOnly
') AS
> [IsIntegratedSecurityOnly]
>
>
>
>
> "Stig Kulvedrsten" <stig@.spire.as> wrote in message
> news:D25D73BE-1B57-4A7D-9509-52E48E9322C7@.microsoft.com...
>|||If you don't , you cannot, unless changing a value in registry ( I don't
recommend you)
You must create a login (to allow connect to SQL Server) then a user to be
mapped to the login to allow access to specific database
"Stig Kulvedrsten" <stig@.spire.as> wrote in message
news:C945D488-FD52-49EF-9CF0-9D2CC27E64E0@.microsoft.com...
> ok. i ran the query and got 1 as a result.
> but how can I change this setting if I dont have any permission?
> Stig
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uo6brH$MHHA.1240@.TK2MSFTNGP03.phx.gbl...
>|||You're not getting access because you're not an administrator when you log
in. In previous OS's you had administrator permissions on the database
because you were an administrator in Windows and that made you an
administrator in SQL. In Vista you don't run as an admin by default. You
have to make yourself a Windows admin before you log into SQL so you have
permissions to change the security settings. By the way, this is why they
say you should be running SQL Server SP2 on Vista.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ODSbuP$MHHA.1240@.TK2MSFTNGP03.phx.gbl...
> If you don't , you cannot, unless changing a value in registry ( I don't
> recommend you)
> You must create a login (to allow connect to SQL Server) then a user to be
> mapped to the login to allow access to specific database
>
>
> "Stig Kulvedrsten" <stig@.spire.as> wrote in message
> news:C945D488-FD52-49EF-9CF0-9D2CC27E64E0@.microsoft.com...
>

Free ebook Download

I registered SQL Server Express and was told that I could download the Ebook Microsoft? SQL Server? 2005 Express Edition eBook. When I go to the portal, it gives me a message that it cannot be downloaded (the site cannot be found. Can someone tell me how to download this book? Thanks in advance.

You download the book from the Benefits portal, if there was an error, it was likely an intermitent thing, you should try again. It's also possible that you have a bad link, but you didn't provide the link you were using, so I can't tell. Try accessing the benefits portal via https://connect.microsoft.com/site/sitehome.aspx?SiteID=40, which should ask you to login, and then see if the download works.

Mike

|||

HI Mike,

The site I was trying to download from was FTP_TK2.ds.microsoft.com. Still cannot get the document. Any ideas?

|||

For good measure, I just logged into the site and attempted to download the book. It came down without a hitch, which tells me that it's not an issue with the download going wonky, which can happen sometimes. The issue must be something related to you specific situation.

Please verify that you were able to log into the Connect site and get to the benefits portal download page. If you are able to do that successfully, please give me the exact steps you are following from that page, when you get the error and the text of the error you're getting.

You may also want to seek help directly from the Connect Support group by submitting a question at https://connect.microsoft.com/Main/ContactUs/EmailSupport.aspx?Category=3.

Mike

|||Same thing happens to me when I register for the benefits, and click the link in the email labeled "Registration Benefit Portal".

It takes me to the MS Connect site with a 404 of:

Page Not Found

The content that you requested cannot be found or you do not have permission to view it.

If you believe you have reached this page in error, click the Contact Us link at the bottom of the page to report the issue and include this ID in your e-mail: 92156a33-0571-4fee-9031-4642f9c59122
|||

click this link --> https://connect.microsoft.com/site/sitehome.aspx?SiteID=40

And tell me what happens.

Mike

|||

Mike,

I got a 404 at 12:23 am PDT on Sep 6, 2007.

I'm guessing that one must be logged into the connect site first. (I'll try that next.)

|||

I recommend http://bookilook.com -> ebook search website.

|||

Though is not what you have asked for but here are some good resource - material on SQL Server that you can refer as Begginner / DBA http://hemantgirisgoswami.blogspot.com/2007/08/resource-for-new-sql-server-dba-and.html

Free ebook Download

I registered SQL Server Express and was told that I could download the Ebook Microsoft? SQL Server? 2005 Express Edition eBook. When I go to the portal, it gives me a message that it cannot be downloaded (the site cannot be found. Can someone tell me how to download this book? Thanks in advance.

You download the book from the Benefits portal, if there was an error, it was likely an intermitent thing, you should try again. It's also possible that you have a bad link, but you didn't provide the link you were using, so I can't tell. Try accessing the benefits portal via https://connect.microsoft.com/site/sitehome.aspx?SiteID=40, which should ask you to login, and then see if the download works.

Mike

|||

HI Mike,

The site I was trying to download from was FTP_TK2.ds.microsoft.com. Still cannot get the document. Any ideas?

|||

For good measure, I just logged into the site and attempted to download the book. It came down without a hitch, which tells me that it's not an issue with the download going wonky, which can happen sometimes. The issue must be something related to you specific situation.

Please verify that you were able to log into the Connect site and get to the benefits portal download page. If you are able to do that successfully, please give me the exact steps you are following from that page, when you get the error and the text of the error you're getting.

You may also want to seek help directly from the Connect Support group by submitting a question at https://connect.microsoft.com/Main/ContactUs/EmailSupport.aspx?Category=3.

Mike

|||Same thing happens to me when I register for the benefits, and click the link in the email labeled "Registration Benefit Portal".

It takes me to the MS Connect site with a 404 of:

Page Not Found

The content that you requested cannot be found or you do not have permission to view it.

If you believe you have reached this page in error, click the Contact Us link at the bottom of the page to report the issue and include this ID in your e-mail: 92156a33-0571-4fee-9031-4642f9c59122
|||

click this link --> https://connect.microsoft.com/site/sitehome.aspx?SiteID=40

And tell me what happens.

Mike

|||

Mike,

I got a 404 at 12:23 am PDT on Sep 6, 2007.

I'm guessing that one must be logged into the connect site first. (I'll try that next.)

|||

I recommend http://bookilook.com -> ebook search website.

|||

Though is not what you have asked for but here are some good resource - material on SQL Server that you can refer as Begginner / DBA http://hemantgirisgoswami.blogspot.com/2007/08/resource-for-new-sql-server-dba-and.html

Free ebook Download

I registered SQL Server Express and was told that I could download the Ebook Microsoft? SQL Server? 2005 Express Edition eBook. When I go to the portal, it gives me a message that it cannot be downloaded (the site cannot be found. Can someone tell me how to download this book? Thanks in advance.

You download the book from the Benefits portal, if there was an error, it was likely an intermitent thing, you should try again. It's also possible that you have a bad link, but you didn't provide the link you were using, so I can't tell. Try accessing the benefits portal via https://connect.microsoft.com/site/sitehome.aspx?SiteID=40, which should ask you to login, and then see if the download works.

Mike

|||

HI Mike,

The site I was trying to download from was FTP_TK2.ds.microsoft.com. Still cannot get the document. Any ideas?

|||

For good measure, I just logged into the site and attempted to download the book. It came down without a hitch, which tells me that it's not an issue with the download going wonky, which can happen sometimes. The issue must be something related to you specific situation.

Please verify that you were able to log into the Connect site and get to the benefits portal download page. If you are able to do that successfully, please give me the exact steps you are following from that page, when you get the error and the text of the error you're getting.

You may also want to seek help directly from the Connect Support group by submitting a question at https://connect.microsoft.com/Main/ContactUs/EmailSupport.aspx?Category=3.

Mike

|||Same thing happens to me when I register for the benefits, and click the link in the email labeled "Registration Benefit Portal".

It takes me to the MS Connect site with a 404 of:

Page Not Found

The content that you requested cannot be found or you do not have permission to view it.

If you believe you have reached this page in error, click the Contact Us link at the bottom of the page to report the issue and include this ID in your e-mail: 92156a33-0571-4fee-9031-4642f9c59122
|||

click this link --> https://connect.microsoft.com/site/sitehome.aspx?SiteID=40

And tell me what happens.

Mike

|||

Mike,

I got a 404 at 12:23 am PDT on Sep 6, 2007.

I'm guessing that one must be logged into the connect site first. (I'll try that next.)

|||

I recommend http://bookilook.com -> ebook search website.

|||

Though is not what you have asked for but here are some good resource - material on SQL Server that you can refer as Begginner / DBA http://hemantgirisgoswami.blogspot.com/2007/08/resource-for-new-sql-server-dba-and.html

Free ebook Download

I registered SQL Server Express and was told that I could download the Ebook Microsoft? SQL Server? 2005 Express Edition eBook. When I go to the portal, it gives me a message that it cannot be downloaded (the site cannot be found. Can someone tell me how to download this book? Thanks in advance.

You download the book from the Benefits portal, if there was an error, it was likely an intermitent thing, you should try again. It's also possible that you have a bad link, but you didn't provide the link you were using, so I can't tell. Try accessing the benefits portal via https://connect.microsoft.com/site/sitehome.aspx?SiteID=40, which should ask you to login, and then see if the download works.

Mike

|||

HI Mike,

The site I was trying to download from was FTP_TK2.ds.microsoft.com. Still cannot get the document. Any ideas?

|||

For good measure, I just logged into the site and attempted to download the book. It came down without a hitch, which tells me that it's not an issue with the download going wonky, which can happen sometimes. The issue must be something related to you specific situation.

Please verify that you were able to log into the Connect site and get to the benefits portal download page. If you are able to do that successfully, please give me the exact steps you are following from that page, when you get the error and the text of the error you're getting.

You may also want to seek help directly from the Connect Support group by submitting a question at https://connect.microsoft.com/Main/ContactUs/EmailSupport.aspx?Category=3.

Mike

|||Same thing happens to me when I register for the benefits, and click the link in the email labeled "Registration Benefit Portal".

It takes me to the MS Connect site with a 404 of:

Page Not Found

The content that you requested cannot be found or you do not have permission to view it.

If you believe you have reached this page in error, click the Contact Us link at the bottom of the page to report the issue and include this ID in your e-mail: 92156a33-0571-4fee-9031-4642f9c59122
|||

click this link --> https://connect.microsoft.com/site/sitehome.aspx?SiteID=40

And tell me what happens.

Mike

|||

Mike,

I got a 404 at 12:23 am PDT on Sep 6, 2007.

I'm guessing that one must be logged into the connect site first. (I'll try that next.)

|||

I recommend http://bookilook.com -> ebook search website.

|||

Though is not what you have asked for but here are some good resource - material on SQL Server that you can refer as Begginner / DBA http://hemantgirisgoswami.blogspot.com/2007/08/resource-for-new-sql-server-dba-and.html

framework 1.1 update + ssmse: get warning!?

Hello, friends,
here is my problem:
I installed sql server express on a naked Windows xp pro with SP2; of course, framework 2.0 installed, and MS-installer 3.1 installed as well. I also installed ssmse. Everything worked fine.
Then I installed all windows updates via Windows Update in internet.
Now suddenly, when starting ssmse, I get a Warning Textbox with Header "Microsoft SQL Server Management Studio Express", then the yellow triangle with the exklamation mark, but NO TEXT AT ALL, and the OK-button. So unfortunately, I do not know what to do. Only thing I found out was, that in all updates, the culprit surely is framework 1.1 update. Before installing this, everything worked fine, afterwards, well, see above.
When I click the ok-button, everything works fine, I can log in into sql server express and do what I have to do.
So my only solution at the moment is just to ignore the warning - not the best way.
Couldn't find a better solution until now.
Could anybody help?

Kind regards from
Axolotl, Mellendorf, Germany

Have you tried to reinstall / repair the management tools again. This would not take long and should re connect any links or references that were lost.

|||

Hello, Glenn,
thanks a lot for your answer.
Unfortunately, I tried that several times, also with a brand new installed windows xp pro sp2.
But, must tell you, I DID find a solution:
I downloaded the sqlexpr_toolkit_ger.exe, installed it, and now this strange message has disappeared, and ssmse is working without any problems...
I think, there might be any file destroyed by updating framework 1.1 which is reinstalled by the toolkit!?
Doesn't matter, it works.

Kind regards from
Axolotl