Monday, March 19, 2012
I upgraded from MSDE to 2005 Express, now my apps get 'login faile
Login failed for user 'my_user'
All of my apps that use ADO are working fine.
I know the userid/password are correct because I use the same ones with my
ADO apps. Does anyone have any ideas?
Thanks in advance!
apf
Nevermind! The root of my problem was - passwords are case sensitive in
2005! If anyone knows how to turn this "option" off, I would appreciate it.
|||It can't be turned off. It was part of improving password strength to
improve security of SQL logins.
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
"apf" <apf@.discussions.microsoft.com> wrote in message
news:2786F0F5-CBDB-4B3A-AAC4-67AADE6A4CF0@.microsoft.com...
> Nevermind! The root of my problem was - passwords are case sensitive in
> 2005! If anyone knows how to turn this "option" off, I would appreciate
> it.
>
I upgraded from MSDE to 2005 Express - now my apps get login faile
Login failed for user 'my_user'
All of my apps that use ADO are working fine.
I know the userid/password are correct because I use the same ones with my
ADO apps. Does anyone have any ideas?
Thanks in advance!
apfSorry for posting in the wrong forum!
The answer, by the way, is passwords are case sensitive in SQL Server 2005.
I upgraded from MSDE to 2005 Express - now my apps get login faile
Login failed for user 'my_user'
All of my apps that use ADO are working fine.
I know the userid/password are correct because I use the same ones with my
ADO apps. Does anyone have any ideas?
Thanks in advance!
apf
Sorry for posting in the wrong forum!
The answer, by the way, is passwords are case sensitive in SQL Server 2005.
I upgraded from MSDE to 2005 Express - now my apps get login faile
Login failed for user 'my_user'
All of my apps that use ADO are working fine.
I know the userid/password are correct because I use the same ones with my
ADO apps. Does anyone have any ideas?
Thanks in advance!
apfSorry for posting in the wrong forum!
The answer, by the way, is passwords are case sensitive in SQL Server 2005.
Monday, March 12, 2012
I too, cannot connect to SQL EXPRESS via different sub-nets
I have been having a problem, each of our departments is on a separate sub net e. 165.10.xx.xx where my server exists on 165.10.10.10 other worksatations upon the same sub net can access the database, where as those on a separate sub-net e.g. 165.10.12.25 cannot.
The particular data base is a an sqlexpress database, which is accessed through an access-front end utilizing ODBC for the connectivity. The user does have access rights via windows security to both the database directory, as well as the front access specific directory. When trying to set up the ODBC driver I cannot browse to the server, I can however type it in e.g. host\sqlexpress i do get through the authentication screen utilizing windows authentication. When I try to change the database from master to the application database I get an error stating database does not exist.
I have confirmed that the sql server is listening (which seemed obvious that same sub-net could get in) I have also assured the problem sub-net workstation is not running any fire wqall blocks or port filters.
--Today I logged on to the work station as myself (system administrator) and I can set up the ODBC driver under my rights, once i typed in the server name, I could see the database I needed. This gave me the idea of adding the user in the problem sub-net to the server administrators group -- which does allow the user access.
I had thought that the secure by design paradigm shift allowed access with minimal rights.
My question is this :
How do I configure the server so that the user is not required to be an administrator on it, so that access to the data can be granted, while keeping a modicum of security on the server?
Any help would be most welcome -- Thanks ;-)
Are you successfully able to connect to the server on subnet 165.10.10.10 from different subnets after making the connecting users admins on the server machine?
It seems very odd that your network connectivity problem would be solved by adding the member to the administrators group. This is not expected and is not required. Are you using IP security in your environment? What is the precise error message that you're receiving when your connection attemp fails?
To get started on how to provision login access for non-administrator users, here's a good page: http://msdn2.microsoft.com/en-us/library/ms189751.aspx. If you look around this part of the documentation you'll find more details on the minimum set of permissions needed for users to successfully login.
Hope this helps,
Vaughn
|||Once I add the user to the Administrators group on the host machine she can connect to the database and function.
What strikes me as odd though, is that i still have to actually type in the host/sqlexpress refrence as it will not show up in the
Which server do you want to connect to?
Server -- combo box
The authentication step works
then I can see the compulsionasset database in the
Change default database to checkbox -- drop down combo
When the user is not an administrator
I still have to type the server name, authentication still works, but the database table does not show up for selection, and typing it in I get an error that it doesn't exist so that the ODBC administrator wizard will not complete.
There are no other errors.
Adding her to the administrators group did get her in though.
|||Oh...
I have given her a login for he domain account within SQLExpress on the appropriate table...
|||Once I add them as administrator they can connect. It does seem crippled though, usually page ione of the ODBC setup wizard lets you choose from a drop down combo box - the server, I must type the full name in as it doesn't see it. then Page 3 usually lets you change the default database -- as an administrator they can see the database -- if not they can only see the default databases master, tempdb and model. Both means appear to connect -- without error messages on page 2 of the wizard.
|||I'm not sure if the drop down combo box and the login problem have the same root cause but here's what I'd suggest for fixing the drop down:
1) Ensure the SQL Server instance has TCP/IP enabled (it almost certainly does since remote admin connections work)
2) Ensure the SQL Browser service is running on the server machine
3) Make sure there are no firewalls (e.g. windows firewall) blocking connectivity to the sql server instance or sqlbrowser. For SQL Browser you can either add the executable or open UDP port 1433. For the name SQLExpress instance you'll need to add the process since the TCP port is dynamic unless you've manually configured it otherwise.
4) Double check that in SQL Server Configuration Manager there's not a "HideInstance" flag set to true for the SQLExpress instance
Checking all of these *should* make the instance show up in the drop down box.
|||All of those have been checked. I can see the server from machines within the same subnet, I cannot from machines on a different subnet. Though those users can browse the host via windows networking., there are other instances that do not show up within the drop down as well, though, again they do when on the same subnet.
All firewalls are external to the network none between subnets.
Again, thanks for any and all help.
I too, cannot connect to SQL EXPRESS via different sub-nets
I have been having a problem, each of our departments is on a separate sub net e. 165.10.xx.xx where my server exists on 165.10.10.10 other worksatations upon the same sub net can access the database, where as those on a separate sub-net e.g. 165.10.12.25 cannot.
The particular data base is a an sqlexpress database, which is accessed through an access-front end utilizing ODBC for the connectivity. The user does have access rights via windows security to both the database directory, as well as the front access specific directory. When trying to set up the ODBC driver I cannot browse to the server, I can however type it in e.g. host\sqlexpress i do get through the authentication screen utilizing windows authentication. When I try to change the database from master to the application database I get an error stating database does not exist.
I have confirmed that the sql server is listening (which seemed obvious that same sub-net could get in) I have also assured the problem sub-net workstation is not running any fire wqall blocks or port filters.
--Today I logged on to the work station as myself (system administrator) and I can set up the ODBC driver under my rights, once i typed in the server name, I could see the database I needed. This gave me the idea of adding the user in the problem sub-net to the server administrators group -- which does allow the user access.
I had thought that the secure by design paradigm shift allowed access with minimal rights.
My question is this :
How do I configure the server so that the user is not required to be an administrator on it, so that access to the data can be granted, while keeping a modicum of security on the server?
Any help would be most welcome -- Thanks ;-)
Are you successfully able to connect to the server on subnet 165.10.10.10 from different subnets after making the connecting users admins on the server machine?
It seems very odd that your network connectivity problem would be solved by adding the member to the administrators group. This is not expected and is not required. Are you using IP security in your environment? What is the precise error message that you're receiving when your connection attemp fails?
To get started on how to provision login access for non-administrator users, here's a good page: http://msdn2.microsoft.com/en-us/library/ms189751.aspx. If you look around this part of the documentation you'll find more details on the minimum set of permissions needed for users to successfully login.
Hope this helps,
Vaughn
|||Once I add the user to the Administrators group on the host machine she can connect to the database and function.
What strikes me as odd though, is that i still have to actually type in the host/sqlexpress refrence as it will not show up in the
Which server do you want to connect to?
Server -- combo box
The authentication step works
then I can see the compulsionasset database in the
Change default database to checkbox -- drop down combo
When the user is not an administrator
I still have to type the server name, authentication still works, but the database table does not show up for selection, and typing it in I get an error that it doesn't exist so that the ODBC administrator wizard will not complete.
There are no other errors.
Adding her to the administrators group did get her in though.
|||Oh...
I have given her a login for he domain account within SQLExpress on the appropriate table...
|||Once I add them as administrator they can connect. It does seem crippled though, usually page ione of the ODBC setup wizard lets you choose from a drop down combo box - the server, I must type the full name in as it doesn't see it. then Page 3 usually lets you change the default database -- as an administrator they can see the database -- if not they can only see the default databases master, tempdb and model. Both means appear to connect -- without error messages on page 2 of the wizard.
|||I'm not sure if the drop down combo box and the login problem have the same root cause but here's what I'd suggest for fixing the drop down:
1) Ensure the SQL Server instance has TCP/IP enabled (it almost certainly does since remote admin connections work)
2) Ensure the SQL Browser service is running on the server machine
3) Make sure there are no firewalls (e.g. windows firewall) blocking connectivity to the sql server instance or sqlbrowser. For SQL Browser you can either add the executable or open UDP port 1433. For the name SQLExpress instance you'll need to add the process since the TCP port is dynamic unless you've manually configured it otherwise.
4) Double check that in SQL Server Configuration Manager there's not a "HideInstance" flag set to true for the SQLExpress instance
Checking all of these *should* make the instance show up in the drop down box.
|||All of those have been checked. I can see the server from machines within the same subnet, I cannot from machines on a different subnet. Though those users can browse the host via windows networking., there are other instances that do not show up within the drop down as well, though, again they do when on the same subnet.
All firewalls are external to the network none between subnets.
Again, thanks for any and all help.
I think this is a bug
2005 Express.
We then deleted SqlServer 2005 leaving just express.
The problem is when we call
DbProviderFactory.CreateDataSourceEnumerator().Get DataSources(), the row
returned has the server name in column [0] and nothing in the other 3 columns.
So our code then assumes that to connect the server is CONUNDRUM (server
name) instead of CONUNDRUM\SQLEXPRESS and that fails. How can we get the
correct name?
ps - I know we can re-install SqlServer 2005 or uninstall and reinstall
Express to fix this. But I want to make sure our code works properly when
someone does this.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
Hi David,
From your description, I understand that:
You found that the function
DbProviderFactory.CreateDataSourceEnumerator().Get DataSources() failed to
get all matched values after you uninstalled SQL Server 2005 from your
machine. You found that your application could only get the server name in
the first column but nothing in the other three columns.
If I have misunderstood, please let me know.
I just wrote a simple test application with the following code:
DbProviderFactory factory = SqlClientFactory.Instance;
DataTable sources =
factory.CreateDataSourceEnumerator().GetDataSource s();
this.textBox1.Text = "SQL Instances:" + sources.Rows.Count +
"\r\n";
textBox1.Text += "Attributes:" + sources.Columns.Count + "\r\n";
for (int r = 0; r < sources.Rows.Count; ++r)
{
textBox1.Text += "Instance " + r + ":\r\n";
for (int i = 0; i < sources.Columns.Count; ++i)
{
textBox1.Text += "[" + r + "," + i + "]: " +
sources.Rows[r][i] + "\r\n";
}
textBox1.Text += "====================\r\n";
}
I first ran it under my computer with SQL Server 2005 Ent and Express
Editions, then ran it under a computer with only SQL Server 2005 Express
edition, but it worked fine on the two conditions.
To reproduce your issue, I moved it to a test machine with both SQL Server
2005 Ent and Express Editions, then I manually uninstalled the SQL Server
2005 Ent Edition, and ran it again, however it still worked fine.
I also used Reflector to check the source code, the internal logical should
be no problem. However I found that there was a timeout setting by a
private variable timeoutTime. Per my test, I found sometimes at the first
time I could not retrieve all the SQL Server instances information, but if
I tried a second time, I could get the information. I think that the
half-baked information at my side is related to the timeout setting. Not
sure if you encounter the similar issue and you may try again if you could
not get the correct information at the first time.
I recommend that you create a simple C# project and copy my code into it
and see if this issue still exists.
If the issue only exists in your application, you my extract your code into
a simple .net project and mail it to me (changliw@.microsoft.com) so that I
can reproduce your issue for further research.
Thanks for using Microsoft Online Managed Newsgroup. If you have any other
questions or concerns, please feel free to let me know.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Here is the result of your test program. But the only server on conundrum is
conundrum/sqlexpress.
SQL Instances:7
Attributes:4
Instance 0:
[0,0]: BELLE
[0,1]:
[0,2]: No
[0,3]: 8.00.194
====================
Instance 1:
[1,0]: BELLE
[1,1]: SQLEXPRESS
[1,2]: No
[1,3]: 9.00.1399.06
====================
Instance 2:
[2,0]: CONUNDRUM
[2,1]:
[2,2]:
[2,3]:
====================
Instance 3:
[3,0]: JASMINE
[3,1]:
[3,2]:
[3,3]:
====================
Instance 4:
[4,0]: LUMIERE
[4,1]:
[4,2]:
[4,3]:
====================
Instance 5:
[5,0]: MINNIE
[5,1]:
[5,2]:
[5,3]:
====================
Instance 6:
[6,0]: PICARD
[6,1]:
[6,2]:
[6,3]:
====================
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi David,
> From your description, I understand that:
> You found that the function
> DbProviderFactory.CreateDataSourceEnumerator().Get DataSources() failed to
> get all matched values after you uninstalled SQL Server 2005 from your
> machine. You found that your application could only get the server name in
> the first column but nothing in the other three columns.
> If I have misunderstood, please let me know.
> I just wrote a simple test application with the following code:
> DbProviderFactory factory = SqlClientFactory.Instance;
> DataTable sources =
> factory.CreateDataSourceEnumerator().GetDataSource s();
> this.textBox1.Text = "SQL Instances:" + sources.Rows.Count +
> "\r\n";
> textBox1.Text += "Attributes:" + sources.Columns.Count + "\r\n";
> for (int r = 0; r < sources.Rows.Count; ++r)
> {
> textBox1.Text += "Instance " + r + ":\r\n";
> for (int i = 0; i < sources.Columns.Count; ++i)
> {
> textBox1.Text += "[" + r + "," + i + "]: " +
> sources.Rows[r][i] + "\r\n";
> }
> textBox1.Text += "====================\r\n";
> }
> I first ran it under my computer with SQL Server 2005 Ent and Express
> Editions, then ran it under a computer with only SQL Server 2005 Express
> edition, but it worked fine on the two conditions.
> To reproduce your issue, I moved it to a test machine with both SQL Server
> 2005 Ent and Express Editions, then I manually uninstalled the SQL Server
> 2005 Ent Edition, and ran it again, however it still worked fine.
> I also used Reflector to check the source code, the internal logical should
> be no problem. However I found that there was a timeout setting by a
> private variable timeoutTime. Per my test, I found sometimes at the first
> time I could not retrieve all the SQL Server instances information, but if
> I tried a second time, I could get the information. I think that the
> half-baked information at my side is related to the timeout setting. Not
> sure if you encounter the similar issue and you may try again if you could
> not get the correct information at the first time.
> I recommend that you create a simple C# project and copy my code into it
> and see if this issue still exists.
> If the issue only exists in your application, you my extract your code into
> a simple .net project and mail it to me (changliw@.microsoft.com) so that I
> can reproduce your issue for further research.
> Thanks for using Microsoft Online Managed Newsgroup. If you have any other
> questions or concerns, please feel free to let me know.
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ====
> When responding to posts, please "Reply to Group" via your newsreader
> so that others may learn and benefit from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
>
>
|||Hi David,
This is indeed a strange behavior, but unfortunately I could not reproduce
your issue. In my local network area, there are about 60 SQL Server
instances, when I ran my application to detect the instances, I could got
all the information of the 60 instances. I also ran the test program on
other 3 machines and still could not reproduce your issue.
After discussing with our tech lead, I recommend that you contact Microsoft
Customer Support Services (CSS) via telephone so that a dedicated Support
Professional can assist you in a more efficient manner. Please be advised
that contacting phone support will be a charged call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
|||
Quote:
Originally Posted by Charles Wang[MSFT]
Hi David,
This is indeed a strange behavior, but unfortunately I could not reproduce
your issue. In my local network area, there are about 60 SQL Server
instances, when I ran my application to detect the instances, I could got
all the information of the 60 instances. I also ran the test program on
other 3 machines and still could not reproduce your issue.
After discussing with our tech lead, I recommend that you contact Microsoft
Customer Support Services (CSS) via telephone so that a dedicated Support
Professional can assist you in a more efficient manner. Please be advised
that contacting phone support will be a charged call.
This code returns the Server and Instance names correctly on my local box (I have three instances installed locally, all with instance names).
However, it returns blank fields for every server on the network (there are a great many servers on the network). I know for a fact that many of these have instance names, but the instance name comes back as null in this code.
So this is definitely something that is not isolated to just the first poster who reported this behavior.
Are there ANY other ideas here? Any suggestions of what might be going on? It sure looks like a bug from my end, but could it be anything in the internal firewalls or any settings in SQL Server? Or the fact that I'm going over VPN? Could there be any VPN or network issues?
Our environment is a mix of SQL Server 2000 and SQL Server 2005. Again, everything is fine on my local box, but the remote servers report no instance names, or versions, or anything else, ever. Just the server name comes back, exactly as the grandparent indicated.|||
Quote:
Originally Posted by Charles Wang[MSFT]
Hi David,
This is indeed a strange behavior, but unfortunately I could not reproduce
your issue. In my local network area, there are about 60 SQL Server
instances, when I ran my application to detect the instances, I could got
all the information of the 60 instances. I also ran the test program on
other 3 machines and still could not reproduce your issue.
After discussing with our tech lead, I recommend that you contact Microsoft
Customer Support Services (CSS) via telephone so that a dedicated Support
Professional can assist you in a more efficient manner. Please be advised
that contacting phone support will be a charged call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default...S;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
I've verified that it's definitely related to networking or VPN.
When I run the code from my VPN'd machine, I don't get back
anything but the server name (no instance name, no version,
just as originally reported by David). But if I take the same
EXE and copy it to a machine inside the actual network and
run it, it sees everything fine.
Can you verify if there are some additional ports that need
opening, or some additional settings that need to be made?
Surely someone ELSE can reproduce this problem, since two
of us experience it so reproducably...
Anyone? Bueller?
I think this is a bug
2005 Express.
We then deleted SqlServer 2005 leaving just express.
The problem is when we call
DbProviderFactory.CreateDataSourceEnumerator().GetDataSources(), the row
returned has the server name in column [0] and nothing in the other 3 co
lumns.
So our code then assumes that to connect the server is CONUNDRUM (server
name) instead of CONUNDRUM\SQLEXPRESS and that fails. How can we get the
correct name?
ps - I know we can re-install SqlServer 2005 or uninstall and reinstall
Express to fix this. But I want to make sure our code works properly when
someone does this.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htmHi David,
From your description, I understand that:
You found that the function
DbProviderFactory.CreateDataSourceEnumerator().GetDataSources() failed to
get all matched values after you uninstalled SQL Server 2005 from your
machine. You found that your application could only get the server name in
the first column but nothing in the other three columns.
If I have misunderstood, please let me know.
I just wrote a simple test application with the following code:
DbProviderFactory factory = SqlClientFactory.Instance;
DataTable sources =
factory.CreateDataSourceEnumerator().GetDataSources();
this.textBox1.Text = "SQL Instances:" + sources.Rows.Count +
"\r\n";
textBox1.Text += "Attributes:" + sources.Columns.Count + "\r\n";
for (int r = 0; r < sources.Rows.Count; ++r)
{
textBox1.Text += "Instance " + r + ":\r\n";
for (int i = 0; i < sources.Columns.Count; ++i)
{
textBox1.Text += "[" + r + "," + i + "]: " +
sources.Rows[r][i] + "\r\n";
}
textBox1.Text += "====================\r\n";
}
I first ran it under my computer with SQL Server 2005 Ent and Express
Editions, then ran it under a computer with only SQL Server 2005 Express
edition, but it worked fine on the two conditions.
To reproduce your issue, I moved it to a test machine with both SQL Server
2005 Ent and Express Editions, then I manually uninstalled the SQL Server
2005 Ent Edition, and ran it again, however it still worked fine.
I also used Reflector to check the source code, the internal logical should
be no problem. However I found that there was a timeout setting by a
private variable timeoutTime. Per my test, I found sometimes at the first
time I could not retrieve all the SQL Server instances information, but if
I tried a second time, I could get the information. I think that the
half-baked information at my side is related to the timeout setting. Not
sure if you encounter the similar issue and you may try again if you could
not get the correct information at the first time.
I recommend that you create a simple C# project and copy my code into it
and see if this issue still exists.
If the issue only exists in your application, you my extract your code into
a simple .net project and mail it to me (changliw@.microsoft.com) so that I
can reproduce your issue for further research.
Thanks for using Microsoft Online Managed Newsgroup. If you have any other
questions or concerns, please feel free to let me know.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Here is the result of your test program. But the only server on conundrum is
conundrum/sqlexpress.
SQL Instances:7
Attributes:4
Instance 0:
[0,0]: BELLE
[0,1]:
[0,2]: No
[0,3]: 8.00.194
====================
Instance 1:
[1,0]: BELLE
[1,1]: SQLEXPRESS
[1,2]: No
[1,3]: 9.00.1399.06
====================
Instance 2:
[2,0]: CONUNDRUM
[2,1]:
[2,2]:
[2,3]:
====================
Instance 3:
[3,0]: JASMINE
[3,1]:
[3,2]:
[3,3]:
====================
Instance 4:
[4,0]: LUMIERE
[4,1]:
[4,2]:
[4,3]:
====================
Instance 5:
[5,0]: MINNIE
[5,1]:
[5,2]:
[5,3]:
====================
Instance 6:
[6,0]: PICARD
[6,1]:
[6,2]:
[6,3]:
====================
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi David,
> From your description, I understand that:
> You found that the function
> DbProviderFactory.CreateDataSourceEnumerator().GetDataSources() failed to
> get all matched values after you uninstalled SQL Server 2005 from your
> machine. You found that your application could only get the server name in
> the first column but nothing in the other three columns.
> If I have misunderstood, please let me know.
> I just wrote a simple test application with the following code:
> DbProviderFactory factory = SqlClientFactory.Instance;
> DataTable sources =
> factory.CreateDataSourceEnumerator().GetDataSources();
> this.textBox1.Text = "SQL Instances:" + sources.Rows.Count +
> "\r\n";
> textBox1.Text += "Attributes:" + sources.Columns.Count + "\r\n
";
> for (int r = 0; r < sources.Rows.Count; ++r)
> {
> textBox1.Text += "Instance " + r + ":\r\n";
> for (int i = 0; i < sources.Columns.Count; ++i)
> {
> textBox1.Text += "[" + r + "," + i + "]: " +
> sources.Rows[r][i] + "\r\n";
> }
> textBox1.Text += "====================\r\n";
> }
> I first ran it under my computer with SQL Server 2005 Ent and Express
> Editions, then ran it under a computer with only SQL Server 2005 Express
> edition, but it worked fine on the two conditions.
> To reproduce your issue, I moved it to a test machine with both SQL Server
> 2005 Ent and Express Editions, then I manually uninstalled the SQL Server
> 2005 Ent Edition, and ran it again, however it still worked fine.
> I also used Reflector to check the source code, the internal logical shoul
d
> be no problem. However I found that there was a timeout setting by a
> private variable timeoutTime. Per my test, I found sometimes at the first
> time I could not retrieve all the SQL Server instances information, but if
> I tried a second time, I could get the information. I think that the
> half-baked information at my side is related to the timeout setting. Not
> sure if you encounter the similar issue and you may try again if you could
> not get the correct information at the first time.
> I recommend that you create a simple C# project and copy my code into it
> and see if this issue still exists.
> If the issue only exists in your application, you my extract your code int
o
> a simple .net project and mail it to me (changliw@.microsoft.com) so that I
> can reproduce your issue for further research.
> Thanks for using Microsoft Online Managed Newsgroup. If you have any other
> questions or concerns, please feel free to let me know.
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via your newsreader
> so that others may learn and benefit from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>
>
>|||Hi David,
This is indeed a strange behavior, but unfortunately I could not reproduce
your issue. In my local network area, there are about 60 SQL Server
instances, when I ran my application to detect the instances, I could got
all the information of the 60 instances. I also ran the test program on
other 3 machines and still could not reproduce your issue.
After discussing with our tech lead, I recommend that you contact Microsoft
Customer Support Services (CSS) via telephone so that a dedicated Support
Professional can assist you in a more efficient manner. Please be advised
that contacting phone support will be a charged call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/defaul...US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
I think I found the solution
I recently (yesterday) installed a fresh copy of Windows XP with Service Pack 2 applied.
I proceeded with Visual Studio 2005 Express Editions installation straight away.
But I cannot install Microsoft SQL Server 2005 Express Edition x86.
I choose to install Microsoft SQL Server 2005 Express Edition x86 component along with every component of visual studio but it simply would not install.
In the end, after the installation of each complete is complete, I simply get an error message saying that Microsoft SQL Server 2005 Express Edition x86 failed to install.
What is the problem?
First take a look at the following file: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\summary.txt. This should point you to which component failed and the specific log file for the component. When you open the component log file search for "Value 3" (this is a Windows Installer code for the error section). Take a look at +/- 10 lines for the error.
If the summary.txt file doesn't provide any clues, take a look at: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\files\*_core(local).txt - open the most recent one if there are multiple. Go to the end of the file and you should find some clues as to why the installation failed.
|||I looked. There were three errors and all of them said that installation cannot be done to a compressed drive
--
Error : SQL Server Setup cannot install files to the compressed or encrypted folder: C:\Program Files\Microsoft SQL Server\. To continue, make sure that your installation directories are not compressed or encrypted, or specify a different directory, and then run SQL Server Setup again.
--
I'll remove drive compression and try again.
Thanks for help!
|||I am having the same problem - cannot install SQL Server Express, I looked in the file you mentioned to the other fellow and it says:
D43QNW81 : SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
but I HAVE removed all components except a thing called Enterprise Library June 2005, and thaat one will not un-install without dot net framework 1.1
is that it? do I have to go ALL the way back?
any help will be much appreciated, I installed the whole works in a Virutal machine and now I am trying to install it on my base machine (because the Virtual one is too slow)
David,
You can take a look at the latest *_core(local).log file to see which old component it's detecting. The log files can be found here: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\files
If you email me directly at dtjones@.microsoft.com I can send you a clean up script. The script isn't supported but we've had good luck with it.
Cheers,
Dan
i really need some help!!!!!!!
well......im from peru....i dont speak english too well.......but...i have the SQL express edition....but when i open it....i gotta to connect to a server.....but i dont have any server.....what do i should put to in "server name" and "authentication"...to star to use the SQL express edition....
well..if there are some grammathical mistakes....sorry...im learnin` english
please answer me
is an emergency!!!!
Jaime
well generally you connect to the local computer\SQLExpress:
(local)\SQLExpress
in regards to authentication, again it depends what type of authentication you set up. Was it Windows/trusted authentication or SQL authentication? if its Windows then you just type in your Windows username followed by the Windows password I believe otherwise its the SQL user account you created
|||well if you can tell me what do i should put in "server name" and "authentication"......i`ll fell better|||servername AFAIK is usually:
(local)\SQLExpress
as for authentication as stated, depends on the type of authentication you have set up. If its Windows, then enter your username and password you use for Windows login. If its SQL user account, enter the username and password for the SQL user account you created.
|||ahmedilyas...im 17...........im learnin SQL in my university....i dont understand what u said.......but-......how do i know the type of authentication i set up?....can u help me please!!!!!!!|||try www.connectionstrings.com
Attach a database file on connect to a local SQL Server Express instance:
"Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;"
- or -
"Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;"
(use |DataDirectory| when your database file resides in the data directory)
Why is the "Database" parameter needed? Answer: If the database was previously attached, SQL Server does not reattach it (it uses the attached database as the default for the connection).
Using "User Instance" on a local SQL Server Express instance:
"Data Source=.\SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|\mydb.mdf;user instance=true;"
The "User Instance" functionality creates a new SQL Server instance on the fly during connect. This works only on a local SQL Server 2005 instance and only when connecting using windows authentication over local named pipes. The purpose is to be able to create a full rights SQL Server instance to a user with limited administrative rights on the computer. To enable the functionality: sp_configure 'user instances enabled','1' (0 to disable)
Using SQL Server 2005 Express? Don't miss the server name syntax: SERVERNAME\SQLEXPRESS (Substitute "SERVERNAME" with the name of the computer)|||
Hi Jamie,
When you installed SQL Express, you installed the server onto your computer. SQL Express installs by default to something called a named instances, which is just the way we refer to the name of the server. As long as you didn't change anything when you were installing, the name of your SQL Express instance is "SQLEXPRESS". When connecting to SQL Server, you have to specify both the machine name and the instance name, in the format <machine name>\<instance name>. In cases where you are connecting to a SQL Server that is on the same machine that your are logged into, you can replace the <machine name> part with either the word "(local)" or with a period "." as form of short hand. So, in order to connect to the default copy of SQL Express on the computer you are logged into, you would put the following in the Server name text box:
(local)\SQLEXPRESS
Normally, SQL Express uses Windows Authentication, which means that SQL will recognize the same user account that you use when logging onto Windows. If you did not change anything when you installed SQL Express, you should just be able to select Windows Authentication and SQL Express will recognize you without providing any additional user name or password.
Hope this helps,
Mike
|||Hi Michael,I love your messages! You are excellent
at explaining answers to problems and queries for beginners.
You're the TOP answer provider on the MSDN site in terms of
quality! Thank you!
For your information, this query is probably a popular one due to that
lack of explanation on the SQL video lesson05. He simply assumes
that you can click on the "Connect" button without any explanation
about server name etc - and any beginner will, of course, probably be
opening SQL Server Management for the first time, so therefore would
require this information to continue further.
Like Me!!!
However, following your instructions, I now have another error message
that, according to your information re local connections sounds bizzaar.
I typed in:
(local)SQLEXPRESS
I left "Windows Authentication" as is.
And clicked connect.
The User Name came up with:
YOUR-6202AC0500\user
(which I vaguely recognise as seen somewhere else and appears to
describe my PC.) My directory for "Documents and Settings" is
"user's Documents" (I obviously haven't named my PC) and the owner is
Fran Smith (in case this is relevant) - sorry - as mentioned, beginner.
The error says the following:
Connect to Server
Cannot connect to (localSQLEXPRESS)
Additional Information:
An error has occurred while establishing a connection to the
server. When connecting to SQL server 2005, this failure may be
caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: Named Pipes Provider,
error: 40 - Could not open a connection to SQL Server)(Microsoft
SQL Server, Error: 53)
There's a little "Show Technical Details" icon at the bottom of the
error message, which I clicked on which provided a "For Help:" http
link. This took me to a page that began "We're sorry.
There's no additional information...". The "Help" icon took me to
the same page.
Why is it seemingly attempting to connect to a remote server when a)
I've specified local and b) it has also even found my PC user
name? What do I do to correct this. I did install it
accepting the defaults provided.
Thank you in advance.
I'm now a little frustrated. I have began the video sequences
(which is a fabulous learning tool because it is explained WHY etc, not
just click here/do this as the written tutorials tend to do); however I
am stuck awaiting answers to all three sequences:
VB - on the
databinding issue: I read the other forums etc, and found the
basic problem regarding the two databases/saving to only the
one/debugging overwrites etc, but I wanted to know how then, do we save
to the actual database, how and when does this occur, if not at that
time? refer VBLesson09.
VWD - userCount
doesn't work for me - either in FireFox (where it doesn't increment) or
in IE7 (where it continues to increment each time a window is
refreshed). refer VWDLesson03
And now, SQL Lesson05.
My other username is BasilTabethaCat. These have been outstanding
for 3 and 2 days respectively, with no reply attempts or answers.
How do I invoke an answer?
I am now stuck as I would rather not continue the learning process
while I have a hole in my understanding (I am a student teacher - so
I'm well informed on the pitfalls of this!)
HELP!!
Cheers,
Fran...
PS I meant the compliment above - your answers in several areas have helped me a lot!
i really need some help!!!!!!!
well......im from peru....i dont speak english too well.......but...i have the SQL express edition....but when i open it....i gotta to connect to a server.....but i dont have any server.....what do i should put to in "server name" and "authentication"...to star to use the SQL express edition....
well..if there are some grammathical mistakes....sorry...im learnin` english
please answer me
is an emergency!!!!
Jaime
well generally you connect to the local computer\SQLExpress:
(local)\SQLExpress
in regards to authentication, again it depends what type of authentication you set up. Was it Windows/trusted authentication or SQL authentication? if its Windows then you just type in your Windows username followed by the Windows password I believe otherwise its the SQL user account you created
|||well if you can tell me what do i should put in "server name" and "authentication"......i`ll fell better|||servername AFAIK is usually:
(local)\SQLExpress
as for authentication as stated, depends on the type of authentication you have set up. If its Windows, then enter your username and password you use for Windows login. If its SQL user account, enter the username and password for the SQL user account you created.
|||ahmedilyas...im 17...........im learnin SQL in my university....i dont understand what u said.......but-......how do i know the type of authentication i set up?....can u help me please!!!!!!!|||try www.connectionstrings.com
Attach a database file on connect to a local SQL Server Express instance:
"Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;"
- or -
"Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;"
(use |DataDirectory| when your database file resides in the data directory)
Why is the "Database" parameter needed? Answer: If the database was previously attached, SQL Server does not reattach it (it uses the attached database as the default for the connection).
Using "User Instance" on a local SQL Server Express instance:
"Data Source=.\SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|\mydb.mdf;user instance=true;"
The "User Instance" functionality creates a new SQL Server instance on the fly during connect. This works only on a local SQL Server 2005 instance and only when connecting using windows authentication over local named pipes. The purpose is to be able to create a full rights SQL Server instance to a user with limited administrative rights on the computer. To enable the functionality: sp_configure 'user instances enabled','1' (0 to disable)
Using SQL Server 2005 Express? Don't miss the server name syntax: SERVERNAME\SQLEXPRESS (Substitute "SERVERNAME" with the name of the computer)|||
Hi Jamie,
When you installed SQL Express, you installed the server onto your computer. SQL Express installs by default to something called a named instances, which is just the way we refer to the name of the server. As long as you didn't change anything when you were installing, the name of your SQL Express instance is "SQLEXPRESS". When connecting to SQL Server, you have to specify both the machine name and the instance name, in the format <machine name>\<instance name>. In cases where you are connecting to a SQL Server that is on the same machine that your are logged into, you can replace the <machine name> part with either the word "(local)" or with a period "." as form of short hand. So, in order to connect to the default copy of SQL Express on the computer you are logged into, you would put the following in the Server name text box:
(local)\SQLEXPRESS
Normally, SQL Express uses Windows Authentication, which means that SQL will recognize the same user account that you use when logging onto Windows. If you did not change anything when you installed SQL Express, you should just be able to select Windows Authentication and SQL Express will recognize you without providing any additional user name or password.
Hope this helps,
Mike
|||Hi Michael,I love your messages! You are excellent
at explaining answers to problems and queries for beginners.
You're the TOP answer provider on the MSDN site in terms of
quality! Thank you!
For your information, this query is probably a popular one due to that
lack of explanation on the SQL video lesson05. He simply assumes
that you can click on the "Connect" button without any explanation
about server name etc - and any beginner will, of course, probably be
opening SQL Server Management for the first time, so therefore would
require this information to continue further.
Like Me!!!
However, following your instructions, I now have another error message
that, according to your information re local connections sounds bizzaar.
I typed in:
(local)SQLEXPRESS
I left "Windows Authentication" as is.
And clicked connect.
The User Name came up with:
YOUR-6202AC0500\user
(which I vaguely recognise as seen somewhere else and appears to
describe my PC.) My directory for "Documents and Settings" is
"user's Documents" (I obviously haven't named my PC) and the owner is
Fran Smith (in case this is relevant) - sorry - as mentioned, beginner.
The error says the following:
Connect to Server
Cannot connect to (localSQLEXPRESS)
Additional Information:
An error has occurred while establishing a connection to the
server. When connecting to SQL server 2005, this failure may be
caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: Named Pipes Provider,
error: 40 - Could not open a connection to SQL Server)(Microsoft
SQL Server, Error: 53)
There's a little "Show Technical Details" icon at the bottom of the
error message, which I clicked on which provided a "For Help:" http
link. This took me to a page that began "We're sorry.
There's no additional information...". The "Help" icon took me to
the same page.
Why is it seemingly attempting to connect to a remote server when a)
I've specified local and b) it has also even found my PC user
name? What do I do to correct this. I did install it
accepting the defaults provided.
Thank you in advance.
I'm now a little frustrated. I have began the video sequences
(which is a fabulous learning tool because it is explained WHY etc, not
just click here/do this as the written tutorials tend to do); however I
am stuck awaiting answers to all three sequences:
VB - on the
databinding issue: I read the other forums etc, and found the
basic problem regarding the two databases/saving to only the
one/debugging overwrites etc, but I wanted to know how then, do we save
to the actual database, how and when does this occur, if not at that
time? refer VBLesson09.
VWD - userCount
doesn't work for me - either in FireFox (where it doesn't increment) or
in IE7 (where it continues to increment each time a window is
refreshed). refer VWDLesson03
And now, SQL Lesson05.
My other username is BasilTabethaCat. These have been outstanding
for 3 and 2 days respectively, with no reply attempts or answers.
How do I invoke an answer?
I am now stuck as I would rather not continue the learning process
while I have a hole in my understanding (I am a student teacher - so
I'm well informed on the pitfalls of this!)
HELP!!
Cheers,
Fran...
PS I meant the compliment above - your answers in several areas have helped me a lot!
Friday, March 9, 2012
i need to migrate from sql 2005 express to sql workgroup edition
hello,
i have no idea what i am doing here and could use some help from someone who knows what they are doing.
i have a proliant ml350 g3 server running windows 2003 server with sql express 2005 software.
all the databases are running in compatibility sql 7 mode.
I would like them to be in sql 2005 mode if possible. Is there a way to upgrade the databases in the process?
here's a plan I came up with:
take sql workgroup 2005 edition evaluation, install it on a machine.
Mount all databases on the machine.
Wipe out the sql express 2005 machine, reinstall workgroup edition on the new server.
but here is my question
is there a way to migrate the data from the workgroup edition over to the new server through a DTS copy process, and if so, will it create a new version of the databases with the proper collation or the proper english?
please let me know. if this works, i will be thrilled!
First, you can upgrade in place by installing workgroup over Express on the same machine. Make sure you indicate you want to upgrade by selecting the Express instance name at the appropriate point during the install.
If you do want to switch machines as part of the upgrade, you can either copy the database files (both .mdf and .ldf) manually or use DTS. Either way, I suspect you're likely to lose logins and some other info - but I'm not a DTS expert so I may be misspeaking. You should post a question in that forum if you are going to consider using DTS.
Books On Line (BOL) has a good description of how to go from one compatibility mode to another. Use the sp_dbcmptlevel stored procedure, either before or after the upgrade.
Paul
|||one more question Paul if you don't mind.
Does the BOL Books on Line article show how to change from the existing collation? I apparently have a "conflict"
when I start the SQL Server Management Studio and right click on any of my databases, they show this error:
"Cannont Show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
-> an exception occured while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
--> Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Compatibility_52_409_30003" in the equal to operation. (Microsoft SQL Server, Error: 468)
I have no idea what this means, which is why I had the idea to transform the packages using DTS?
please let me know if you have an answer. If this is for another forum, please let me know that. Thanks for your help.
|||I would post the question about collation in the tools forum. Are Management Studio and Express on the same box? I have no idea what would cause such an error.
Paul
|||thanks this has helped tremendeously.
I still have problems with collation but it looks like the SQL Server default collation and the master/temp/model db are different and this is causing problems.
I need to find a tool to rebuild the master and temp and model db.
One came with SQL 2000 but I do not have one for SQL 2005.
I am still searching for rbuild.exe to use.
hopefully I'll find it!
thanks,
j
Wednesday, March 7, 2012
I need to generate the query to build a database ive designed. Please help..
I've registered with GoDaddy for my site. I've used Visual Web Dev 2005 with SQL Server Mgmt Express 2005 to create my database etc. Now with GoDaddy, I need to "recreate" the database on their server again, but I don't want to go throug the whole process again. I just want to use their query editor to generate the database online.
GoDaddy mentions a "personal-sql" file that SQL Server 2000 generates, but I can't find anything like that with what I have.
Thanks.
Did you try automatically generating the scripts?
In Studio Express, right click on your database.
Select Tasks...Generate Scripts...
You can also generate scripts on a table by table basis.
I need SQL Server Management Studio!
I have just completely installed MS SQL Server 2005 Express Edition in MS Server 2003.
After installation, I only have the Configuration Manager, Error and Usage Reporting and Surface Area Configuration, listed under Configuration Details.
SQL Server Management Studio is not accessible anywhere.
I also do not have the folder C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell in which the SQL Server Management Studio is installed.
What must I do to get this component installed?
In this article http://msdn2.microsoft.com/en-us/library/ms143219.aspx, it is also written in step 8 that there should be a "Components to Install" page. I have done the installations and uninstallations a few times, but I still do not have "Components to Install" page. In fact, after step 7, I am brought to the "Features Selection" page.
What can I do to solve this problem? Please help.
Thanks.
You'll need to download the SQL Server Express Edition Toolkit. Get it at the following page:
http://msdn2.microsoft.com/en-gb/express/bb410792.aspx
HTH!
|||Thanks, it has helped a lot!