I am a newbie to SQL server. I have installed SQL server on my PC. I have created a local server on my machine. When i go to the SQL server wizard to register my server and it gives me the option to connect i am getting the message: SQL server does not exist or access denied. Now i was told that this may be due to my firewall. I have turned these off..and am still getting the message.
Please help
JohnHi John,
What was the authentication mode that you selected while installing the SQL
Server ?
If you have created in Mixed mode, What is the SA Password ?
Is it blank ?
Did you create a named instance or is it the default instance ?
If you have created a named instance, what is the name that you
have assigned to this new instance ?
Just a step by step info, in case you have missed one.
1. "Select a Server" Step
If your instllation is the default installation, then
type your computer name for the "Available Servers" and click on
Add.
If your installation is the Named instance, then
type the server name as "Computername\InstanceName" for the
"Available Servers" and click on ADD.
2. "Select an Authentication Mode" step
If you have selected Mixed Mode authentication, then select
"The SQL Server Login information that was assigned to me by
the system administrator"
3. If you select SQL Server login, you get this additional step "Select
Connection Option"
select first option "Login Automatically using my SQL Server account
information"
Login Name : SA
Password : <The password that you have set> or leave it
blank, if you had set it blank.
4. "Select SQL Server Group" step
select "Add the SQL Server(s) to an existing SQL Server Group".
5. Click on Finish, to get connected to the SQL Server.
With this simple steps you should be able to register the SQL Server in
Enterprise Manager.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Showing posts with label wizard. Show all posts
Showing posts with label wizard. Show all posts
Sunday, March 25, 2012
connection problem
I am a newbie to SQL server. I have installed SQL server on my PC. I have created a local server on my machine. When i go to the SQL server wizard to register my server and it gives me the option to connect i am getting the message: SQL server does not ex
ist or access denied. Now i was told that this may be due to my firewall. I have turned these off..and am still getting the message.
Please help?
John
Hi John,
What was the authentication mode that you selected while installing the SQL
Server ?
If you have created in Mixed mode, What is the SA Password ?
Is it blank ?
Did you create a named instance or is it the default instance ?
If you have created a named instance, what is the name that you
have assigned to this new instance ?
Just a step by step info, in case you have missed one.
1. "Select a Server" Step
If your instllation is the default installation, then
type your computer name for the "Available Servers" and click on
Add.
If your installation is the Named instance, then
type the server name as "Computername\InstanceName" for the
"Available Servers" and click on ADD.
2. "Select an Authentication Mode" step
If you have selected Mixed Mode authentication, then select
"The SQL Server Login information that was assigned to me by
the system administrator"
3. If you select SQL Server login, you get this additional step "Select
Connection Option"
select first option "Login Automatically using my SQL Server account
information"
Login Name : SA
Password : <The password that you have set> or leave it
blank, if you had set it blank.
4. "Select SQL Server Group" step
select "Add the SQL Server(s) to an existing SQL Server Group".
5. Click on Finish, to get connected to the SQL Server.
With this simple steps you should be able to register the SQL Server in
Enterprise Manager.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
ist or access denied. Now i was told that this may be due to my firewall. I have turned these off..and am still getting the message.
Please help?
John
Hi John,
What was the authentication mode that you selected while installing the SQL
Server ?
If you have created in Mixed mode, What is the SA Password ?
Is it blank ?
Did you create a named instance or is it the default instance ?
If you have created a named instance, what is the name that you
have assigned to this new instance ?
Just a step by step info, in case you have missed one.
1. "Select a Server" Step
If your instllation is the default installation, then
type your computer name for the "Available Servers" and click on
Add.
If your installation is the Named instance, then
type the server name as "Computername\InstanceName" for the
"Available Servers" and click on ADD.
2. "Select an Authentication Mode" step
If you have selected Mixed Mode authentication, then select
"The SQL Server Login information that was assigned to me by
the system administrator"
3. If you select SQL Server login, you get this additional step "Select
Connection Option"
select first option "Login Automatically using my SQL Server account
information"
Login Name : SA
Password : <The password that you have set> or leave it
blank, if you had set it blank.
4. "Select SQL Server Group" step
select "Add the SQL Server(s) to an existing SQL Server Group".
5. Click on Finish, to get connected to the SQL Server.
With this simple steps you should be able to register the SQL Server in
Enterprise Manager.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
connection problem
I am a newbie to SQL server. I have installed SQL server on my PC. I have cr
eated a local server on my machine. When i go to the SQL server wizard to re
gister my server and it gives me the option to connect i am getting the mess
age: SQL server does not ex
ist or access denied. Now i was told that this may be due to my firewall. I
have turned these off..and am still getting the message.
Please help?
JohnHi John,
What was the authentication mode that you selected while installing the SQL
Server ?
If you have created in Mixed mode, What is the SA Password ?
Is it blank ?
Did you create a named instance or is it the default instance ?
If you have created a named instance, what is the name that you
have assigned to this new instance ?
Just a step by step info, in case you have missed one.
1. "Select a Server" Step
If your instllation is the default installation, then
type your computer name for the "Available Servers" and click on
Add.
If your installation is the Named instance, then
type the server name as "Computername\InstanceName" for the
"Available Servers" and click on ADD.
2. "Select an Authentication Mode" step
If you have selected Mixed Mode authentication, then select
"The SQL Server Login information that was assigned to me by
the system administrator"
3. If you select SQL Server login, you get this additional step "Select
Connection Option"
select first option "Login Automatically using my SQL Server account
information"
Login Name : SA
Password : <The password that you have set> or leave it
blank, if you had set it blank.
4. "Select SQL Server Group" step
select "Add the SQL Server(s) to an existing SQL Server Group".
5. Click on Finish, to get connected to the SQL Server.
With this simple steps you should be able to register the SQL Server in
Enterprise Manager.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
eated a local server on my machine. When i go to the SQL server wizard to re
gister my server and it gives me the option to connect i am getting the mess
age: SQL server does not ex
ist or access denied. Now i was told that this may be due to my firewall. I
have turned these off..and am still getting the message.
Please help?
JohnHi John,
What was the authentication mode that you selected while installing the SQL
Server ?
If you have created in Mixed mode, What is the SA Password ?
Is it blank ?
Did you create a named instance or is it the default instance ?
If you have created a named instance, what is the name that you
have assigned to this new instance ?
Just a step by step info, in case you have missed one.
1. "Select a Server" Step
If your instllation is the default installation, then
type your computer name for the "Available Servers" and click on
Add.
If your installation is the Named instance, then
type the server name as "Computername\InstanceName" for the
"Available Servers" and click on ADD.
2. "Select an Authentication Mode" step
If you have selected Mixed Mode authentication, then select
"The SQL Server Login information that was assigned to me by
the system administrator"
3. If you select SQL Server login, you get this additional step "Select
Connection Option"
select first option "Login Automatically using my SQL Server account
information"
Login Name : SA
Password : <The password that you have set> or leave it
blank, if you had set it blank.
4. "Select SQL Server Group" step
select "Add the SQL Server(s) to an existing SQL Server Group".
5. Click on Finish, to get connected to the SQL Server.
With this simple steps you should be able to register the SQL Server in
Enterprise Manager.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Thursday, March 8, 2012
Connection failed error during upsizing of an Access database to SQl Server Express databa
Hello,
In order to utilize an Access database as SQL Server database I use
Upsize wizard. I use (Local) SQL server and Trusted Connection. After some
wait I get the following error:
Connection failed:
SQL State:'01000'
SQL error Error:2
[Microsoft][ODBC Server Driver][Shared
Memory]ConnectionOpen(Connect())
Connection Failed:
SQL State:'08001'
SQL server Error:17
[Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not
exist or access is denied
Under VS2008 I can connect to Northwind SQLServer Express database and
manipulate the data OK. So what can I do? Thank you.
Athena
Hello,
I found what's wrong. Server name comes by default as (local) I changed
to right one. It worked.
Athena
"Athena" <Nospam@.nospam.com> wrote in message
news:4616FCF7-A008-4D57-9FBE-480455B4E162@.microsoft.com...
> Hello,
> In order to utilize an Access database as SQL Server database I use
> Upsize wizard. I use (Local) SQL server and Trusted Connection. After some
> wait I get the following error:
> Connection failed:
> SQL State:'01000'
> SQL error Error:2
> [Microsoft][ODBC Server Driver][Shared
> Memory]ConnectionOpen(Connect())
> Connection Failed:
> SQL State:'08001'
> SQL server Error:17
> [Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not
> exist or access is denied
> Under VS2008 I can connect to Northwind SQLServer Express database and
> manipulate the data OK. So what can I do? Thank you.
> Athena
In order to utilize an Access database as SQL Server database I use
Upsize wizard. I use (Local) SQL server and Trusted Connection. After some
wait I get the following error:
Connection failed:
SQL State:'01000'
SQL error Error:2
[Microsoft][ODBC Server Driver][Shared
Memory]ConnectionOpen(Connect())
Connection Failed:
SQL State:'08001'
SQL server Error:17
[Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not
exist or access is denied
Under VS2008 I can connect to Northwind SQLServer Express database and
manipulate the data OK. So what can I do? Thank you.
Athena
Hello,
I found what's wrong. Server name comes by default as (local) I changed
to right one. It worked.
Athena
"Athena" <Nospam@.nospam.com> wrote in message
news:4616FCF7-A008-4D57-9FBE-480455B4E162@.microsoft.com...
> Hello,
> In order to utilize an Access database as SQL Server database I use
> Upsize wizard. I use (Local) SQL server and Trusted Connection. After some
> wait I get the following error:
> Connection failed:
> SQL State:'01000'
> SQL error Error:2
> [Microsoft][ODBC Server Driver][Shared
> Memory]ConnectionOpen(Connect())
> Connection Failed:
> SQL State:'08001'
> SQL server Error:17
> [Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not
> exist or access is denied
> Under VS2008 I can connect to Northwind SQLServer Express database and
> manipulate the data OK. So what can I do? Thank you.
> Athena
Wednesday, March 7, 2012
Connection Error using SQL Server ODBC
Hi, I'm trying to connect to an SQL Server using an ODBC driver, typed in the
Machine name, but it won't let me connect.
Where the wizard asks me what the server name is that I want to connect to,
the drop down is empty. I thought it should show me a list of servers to
choose from?
Also, if I try to type in the machine name, and connect, it gives me an
error that it either could not connect or I am unauthorized even though I
know I'm using the administrators login and password.
I'm sooooooo confused. Am I even using the right ODBC driver? It's [SQL
Server], and they tell me the database is SQL Servcer v.8...
Any ideas?
THANKS!!
In the ODBC set up there are several ways to connect...
When setting it up you need to make sure that you click on client
configuraiton and choose a connection that your SQL Server allows. TCP/IP is
pretty typical on port 1433. Then you must make sure that your SQL server
allows connections using TCP/IP using your client configuration tools.
You also want to check simple things like making sure you can ping the
server (if your firewall allows it) to make sure that you can resolve your
server using DNS...
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"KRISTEN" <KRISTEN@.discussions.microsoft.com> wrote in message
news:B76386D1-75FB-4673-AC9B-FF501DB58D87@.microsoft.com...
> Hi, I'm trying to connect to an SQL Server using an ODBC driver, typed in
> the
> Machine name, but it won't let me connect.
> Where the wizard asks me what the server name is that I want to connect
> to,
> the drop down is empty. I thought it should show me a list of servers to
> choose from?
> Also, if I try to type in the machine name, and connect, it gives me an
> error that it either could not connect or I am unauthorized even though I
> know I'm using the administrators login and password.
> I'm sooooooo confused. Am I even using the right ODBC driver? It's [SQL
> Server], and they tell me the database is SQL Servcer v.8...
> Any ideas?
> THANKS!!
Machine name, but it won't let me connect.
Where the wizard asks me what the server name is that I want to connect to,
the drop down is empty. I thought it should show me a list of servers to
choose from?
Also, if I try to type in the machine name, and connect, it gives me an
error that it either could not connect or I am unauthorized even though I
know I'm using the administrators login and password.
I'm sooooooo confused. Am I even using the right ODBC driver? It's [SQL
Server], and they tell me the database is SQL Servcer v.8...
Any ideas?
THANKS!!
In the ODBC set up there are several ways to connect...
When setting it up you need to make sure that you click on client
configuraiton and choose a connection that your SQL Server allows. TCP/IP is
pretty typical on port 1433. Then you must make sure that your SQL server
allows connections using TCP/IP using your client configuration tools.
You also want to check simple things like making sure you can ping the
server (if your firewall allows it) to make sure that you can resolve your
server using DNS...
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"KRISTEN" <KRISTEN@.discussions.microsoft.com> wrote in message
news:B76386D1-75FB-4673-AC9B-FF501DB58D87@.microsoft.com...
> Hi, I'm trying to connect to an SQL Server using an ODBC driver, typed in
> the
> Machine name, but it won't let me connect.
> Where the wizard asks me what the server name is that I want to connect
> to,
> the drop down is empty. I thought it should show me a list of servers to
> choose from?
> Also, if I try to type in the machine name, and connect, it gives me an
> error that it either could not connect or I am unauthorized even though I
> know I'm using the administrators login and password.
> I'm sooooooo confused. Am I even using the right ODBC driver? It's [SQL
> Server], and they tell me the database is SQL Servcer v.8...
> Any ideas?
> THANKS!!
Connection Error using SQL Server ODBC
Hi, I'm trying to connect to an SQL Server using an ODBC driver, typed in th
e
Machine name, but it won't let me connect.
Where the wizard asks me what the server name is that I want to connect to,
the drop down is empty. I thought it should show me a list of servers to
choose from?
Also, if I try to type in the machine name, and connect, it gives me an
error that it either could not connect or I am unauthorized even though I
know I'm using the administrators login and password.
I'm sooooooo confused. Am I even using the right ODBC driver? It's [SQ
L
Server], and they tell me the database is SQL Servcer v.8...
Any ideas?
THANKS!!In the ODBC set up there are several ways to connect...
When setting it up you need to make sure that you click on client
configuraiton and choose a connection that your SQL Server allows. TCP/IP is
pretty typical on port 1433. Then you must make sure that your SQL server
allows connections using TCP/IP using your client configuration tools.
You also want to check simple things like making sure you can ping the
server (if your firewall allows it) to make sure that you can resolve your
server using DNS...
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"KRISTEN" <KRISTEN@.discussions.microsoft.com> wrote in message
news:B76386D1-75FB-4673-AC9B-FF501DB58D87@.microsoft.com...
> Hi, I'm trying to connect to an SQL Server using an ODBC driver, typed in
> the
> Machine name, but it won't let me connect.
> Where the wizard asks me what the server name is that I want to connect
> to,
> the drop down is empty. I thought it should show me a list of servers to
> choose from?
> Also, if I try to type in the machine name, and connect, it gives me an
> error that it either could not connect or I am unauthorized even though I
> know I'm using the administrators login and password.
> I'm sooooooo confused. Am I even using the right ODBC driver? It's [
SQL
> Server], and they tell me the database is SQL Servcer v.8...
> Any ideas?
> THANKS!!
e
Machine name, but it won't let me connect.
Where the wizard asks me what the server name is that I want to connect to,
the drop down is empty. I thought it should show me a list of servers to
choose from?
Also, if I try to type in the machine name, and connect, it gives me an
error that it either could not connect or I am unauthorized even though I
know I'm using the administrators login and password.
I'm sooooooo confused. Am I even using the right ODBC driver? It's [SQ
L
Server], and they tell me the database is SQL Servcer v.8...
Any ideas?
THANKS!!In the ODBC set up there are several ways to connect...
When setting it up you need to make sure that you click on client
configuraiton and choose a connection that your SQL Server allows. TCP/IP is
pretty typical on port 1433. Then you must make sure that your SQL server
allows connections using TCP/IP using your client configuration tools.
You also want to check simple things like making sure you can ping the
server (if your firewall allows it) to make sure that you can resolve your
server using DNS...
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"KRISTEN" <KRISTEN@.discussions.microsoft.com> wrote in message
news:B76386D1-75FB-4673-AC9B-FF501DB58D87@.microsoft.com...
> Hi, I'm trying to connect to an SQL Server using an ODBC driver, typed in
> the
> Machine name, but it won't let me connect.
> Where the wizard asks me what the server name is that I want to connect
> to,
> the drop down is empty. I thought it should show me a list of servers to
> choose from?
> Also, if I try to type in the machine name, and connect, it gives me an
> error that it either could not connect or I am unauthorized even though I
> know I'm using the administrators login and password.
> I'm sooooooo confused. Am I even using the right ODBC driver? It's [
SQL
> Server], and they tell me the database is SQL Servcer v.8...
> Any ideas?
> THANKS!!
Friday, February 24, 2012
Connection designer in RS 2005?
I have upgraded our Custom Data Extension from SQL 2000 Reporting Services
to 2005. I see that the Report Wizard will now launch my Query Designer for
editing command strings (thank you!) but I still can not see a way to get RS
to launch my "Connection Designer" dialog. When running Report Wizard or
Add New Data Source dialog, the "Edit" button becomes greyed out when I
change the Data Source Type to my Provider. How can I plug my Connection
String editor user interface at this point?
Thanks!Hello Stephen,
This is a quick note that I am consulting in the internal discussion group
to discuss this issue. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Any update on this issue?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:an29mv$yGHA.3392@.TK2MSFTNGXA01.phx.gbl...
> Hello Stephen,
> This is a quick note that I am consulting in the internal discussion group
> to discuss this issue. I appreciate your patience.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
>|||Hello Stephen,
Sorry Stephen, I did not get update from the discussion group, I am still
performing research now. Thank you for your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello Stephen,
How are you doing on this issue? I'm posting to inform you that we're still
focus on this issue, since Wei is absent due to some urgent issue, he'll
udpate you when he get any update from product team later.
Meanwhile, if you have any further questions or concerns, please feel free
to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||I look forward to the resolution of this importan issue. Thansk for staying
on top of it.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:ArAs09k1GHA.4464@.TK2MSFTNGXA01.phx.gbl...
> Hello Stephen,
> How are you doing on this issue? I'm posting to inform you that we're
> still
> focus on this issue, since Wei is absent due to some urgent issue, he'll
> udpate you when he get any update from product team later.
> Meanwhile, if you have any further questions or concerns, please feel free
> to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Stephen,
Unfortunately, I got the response from the product team that Report
Designer does not support customer-written connection string editors at
this time.
I also contact to them that whether this feature is under consideration. So
far, I do not get the feedback on this.
If I get any information, I will update you ASAP.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello,
From the feedback of product team, they will add this to their list of
potential considerations.
For now, if you have any concerns, please feel free to send your feedback
to product team:
http://connect.microsoft.com/SQLServer.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)
to 2005. I see that the Report Wizard will now launch my Query Designer for
editing command strings (thank you!) but I still can not see a way to get RS
to launch my "Connection Designer" dialog. When running Report Wizard or
Add New Data Source dialog, the "Edit" button becomes greyed out when I
change the Data Source Type to my Provider. How can I plug my Connection
String editor user interface at this point?
Thanks!Hello Stephen,
This is a quick note that I am consulting in the internal discussion group
to discuss this issue. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Any update on this issue?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:an29mv$yGHA.3392@.TK2MSFTNGXA01.phx.gbl...
> Hello Stephen,
> This is a quick note that I am consulting in the internal discussion group
> to discuss this issue. I appreciate your patience.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
>|||Hello Stephen,
Sorry Stephen, I did not get update from the discussion group, I am still
performing research now. Thank you for your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello Stephen,
How are you doing on this issue? I'm posting to inform you that we're still
focus on this issue, since Wei is absent due to some urgent issue, he'll
udpate you when he get any update from product team later.
Meanwhile, if you have any further questions or concerns, please feel free
to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||I look forward to the resolution of this importan issue. Thansk for staying
on top of it.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:ArAs09k1GHA.4464@.TK2MSFTNGXA01.phx.gbl...
> Hello Stephen,
> How are you doing on this issue? I'm posting to inform you that we're
> still
> focus on this issue, since Wei is absent due to some urgent issue, he'll
> udpate you when he get any update from product team later.
> Meanwhile, if you have any further questions or concerns, please feel free
> to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Stephen,
Unfortunately, I got the response from the product team that Report
Designer does not support customer-written connection string editors at
this time.
I also contact to them that whether this feature is under consideration. So
far, I do not get the feedback on this.
If I get any information, I will update you ASAP.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello,
From the feedback of product team, they will add this to their list of
potential considerations.
For now, if you have any concerns, please feel free to send your feedback
to product team:
http://connect.microsoft.com/SQLServer.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Friday, February 17, 2012
Connecting using Enterprise Manager
Running SQL2000 on Windows NT. Using Enterprise Manager I
have registered a new server. When I register the server
using the wizard, I set the authentication to Windows.
This allows connection using Enterprise Manager.
For a number of reasons I want to change the
authentication to allow 'Mixed mode' but if I go to the
server properties, security tab and try and change the
authentication to SQL and Windows, the change is not saved
(I cant change the authentication this way)
If I edit the server registration to SQL and specify a Log
in and password, I get the message " Not associated with
Trusted SQL server connection"
Can anyone tell me how to set up the server to allow mixed
mode working. Other servers on the network are fine
Thanks in advance for any helpDid you restart the SQL Server service after changing the security mode?
When you make a change in SQL configuration, it becomes a configured value,
but you have to restart for it becoming a running value.
You may want to check the SQL errorlog and Windows Event viewer as well for
detail. You are definitely going to the right place in Enterprise Manager.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Duncan Stott" <Duncan@.intracite.com> wrote in message
news:74bf01c3e747$79074640$a501280a@.phx.gbl...
permission to change the registry.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Andy
Thanks for the ideas, but I had already tried this. I have
also tried deleting the registration and setting it from
scratch. Same problem. As soon as I specify that I want to
log in usin SQL( not windows) I get the 'Not associated
with Trusted SQL server connection"
I looked in the SQL log as you suggested and there is the
following message
"Configuration option 'show advanced option' changed from
1 to 1. Run the RECONFIGURE statement to instal."
Any ideas
Duncan
security mode?
configured value,
viewer as well for
Enterprise Manager.
*********
updates.
*********
have registered a new server. When I register the server
using the wizard, I set the authentication to Windows.
This allows connection using Enterprise Manager.
For a number of reasons I want to change the
authentication to allow 'Mixed mode' but if I go to the
server properties, security tab and try and change the
authentication to SQL and Windows, the change is not saved
(I cant change the authentication this way)
If I edit the server registration to SQL and specify a Log
in and password, I get the message " Not associated with
Trusted SQL server connection"
Can anyone tell me how to set up the server to allow mixed
mode working. Other servers on the network are fine
Thanks in advance for any helpDid you restart the SQL Server service after changing the security mode?
When you make a change in SQL configuration, it becomes a configured value,
but you have to restart for it becoming a running value.
You may want to check the SQL errorlog and Windows Event viewer as well for
detail. You are definitely going to the right place in Enterprise Manager.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Duncan Stott" <Duncan@.intracite.com> wrote in message
news:74bf01c3e747$79074640$a501280a@.phx.gbl...
quote:|||It sounds like the account that you are logged on as does not have
> Running SQL2000 on Windows NT. Using Enterprise Manager I
> have registered a new server. When I register the server
> using the wizard, I set the authentication to Windows.
> This allows connection using Enterprise Manager.
> For a number of reasons I want to change the
> authentication to allow 'Mixed mode' but if I go to the
> server properties, security tab and try and change the
> authentication to SQL and Windows, the change is not saved
> (I cant change the authentication this way)
> If I edit the server registration to SQL and specify a Log
> in and password, I get the message " Not associated with
> Trusted SQL server connection"
> Can anyone tell me how to set up the server to allow mixed
> mode working. Other servers on the network are fine
> Thanks in advance for any help
>
permission to change the registry.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Andy
Thanks for the ideas, but I had already tried this. I have
also tried deleting the registration and setting it from
scratch. Same problem. As soon as I specify that I want to
log in usin SQL( not windows) I get the 'Not associated
with Trusted SQL server connection"
I looked in the SQL log as you suggested and there is the
following message
"Configuration option 'show advanced option' changed from
1 to 1. Run the RECONFIGURE statement to instal."
Any ideas
Duncan
quote:
>--Original Message--
>Did you restart the SQL Server service after changing the
security mode?
quote:
>When you make a change in SQL configuration, it becomes a
configured value,
quote:
>but you have to restart for it becoming a running value.
>You may want to check the SQL errorlog and Windows Event
viewer as well for
quote:
>detail. You are definitely going to the right place in
Enterprise Manager.
quote:
>--
> ****************************************
******************
*********
quote:
>Andy S.
>MCSE NT/2000, MCDBA SQL 7/2000
>andymcdba1@.NOMORESPAM.yahoo.com
>Please remove NOMORESPAM before replying.
>Always keep your antivirus and Microsoft software
>up to date with the latest definitions and product
updates.
quote:
>Be suspicious of every email attachment, I will never send
>or post anything other than the text of a http:// link nor
>post the link directly to a file for downloading.
>This posting is provided "as is" with no warranties
>and confers no rights.
> ****************************************
******************
*********
quote:
>"Duncan Stott" <Duncan@.intracite.com> wrote in message
>news:74bf01c3e747$79074640$a501280a@.phx.gbl...
I[QUOTE]
saved[QUOTE]
Log[QUOTE]
mixed[QUOTE]
>
>.
>
Subscribe to:
Posts (Atom)