Need help. I changed my TCP connect port for SQL2005 to port 9601.
(ON THE SERVER..went into SQL Config manager >
SQL 2005 Net Config / TCPIP Properties
Changed TCP Port to 9601
Changed TCP PORT for IP2 section to 9601 where ip is 127.0.0.1
Changed TCP for IPAll section to 9601
Dynamic TCP Port was unchanged and remained blank..
Under SQL Config Manager > SQL Native Client Network
Changed TCP PORT to 9601
--
On my laptop went to
SQL Server Config manager
Changed TCP Port to 9601
under SQL Native Client /
Client Protocols / TCPIP..
REBOOTED EVERYONE..
I have a vb.net app, tried to access SQL DB and it failed, so I added the
new port (9601) in the connect
string, and then it worked, so I know the server port was changed to 9601.
However, can no longer connect VIA SQL 2005 Management STUDIO, says
An error has occ while establich connect... TCP Provider error: No
connection could be
made.. target machine actively refused it. Error #10061).
The vb.net app works with new port, why doesn't SQL Management studio?
Changed back to 1433 and everything works again. I've got to change the
port,
How can I and get SQL Management studio to work with a non default port?
Tried the Management studio on another machine.. same error, although vb.net
app connects fine under new port. This is crazy..
The server has an internet Ip address and I am accesing it via .com name (
in the vb.net app too)
( I tried the straight IP address, didn't work either)
Thanks BUCI stumbled across the answer, if I change the default port, I HAVE to create
an alias name and use it in the login box instead of the servername itself..
BUC
<Buc> wrote in message news:%23rm9$GUSGHA.4600@.TK2MSFTNGP11.phx.gbl...
> Need help. I changed my TCP connect port for SQL2005 to port 9601.
> (ON THE SERVER..went into SQL Config manager >
> SQL 2005 Net Config / TCPIP Properties
> Changed TCP Port to 9601
> Changed TCP PORT for IP2 section to 9601 where ip is 127.0.0.1
> Changed TCP for IPAll section to 9601
> Dynamic TCP Port was unchanged and remained blank..
> Under SQL Config Manager > SQL Native Client Network
> Changed TCP PORT to 9601
> --
> On my laptop went to
> SQL Server Config manager
> Changed TCP Port to 9601
> under SQL Native Client /
> Client Protocols / TCPIP..
> REBOOTED EVERYONE..
> I have a vb.net app, tried to access SQL DB and it failed, so I added the
> new port (9601) in the connect
> string, and then it worked, so I know the server port was changed to 9601.
> However, can no longer connect VIA SQL 2005 Management STUDIO, says
> An error has occ while establich connect... TCP Provider error: No
> connection could be
> made.. target machine actively refused it. Error #10061).
> The vb.net app works with new port, why doesn't SQL Management studio?
> Changed back to 1433 and everything works again. I've got to change the
> port,
> How can I and get SQL Management studio to work with a non default port?
> Tried the Management studio on another machine.. same error, although
> vb.net app connects fine under new port. This is crazy..
> The server has an internet Ip address and I am accesing it via .com name
> ( in the vb.net app too)
> ( I tried the straight IP address, didn't work either)
> Thanks BUC
>|||Sounds like you don't have the sqlbrowser service running. The browser
service maps incoming requests to the port where the database is listening
so without the sqlbrowser service running, you have to specify the port in
the connect string.
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
<Buc> wrote in message news:OzOFXlUSGHA.524@.TK2MSFTNGP10.phx.gbl...
>I stumbled across the answer, if I change the default port, I HAVE to
>create an alias name and use it in the login box instead of the servername
>itself..
> BUC
> <Buc> wrote in message news:%23rm9$GUSGHA.4600@.TK2MSFTNGP11.phx.gbl...
>
Showing posts with label config. Show all posts
Showing posts with label config. Show all posts
Thursday, March 29, 2012
Tuesday, March 20, 2012
can't access MSDE database after setup
I can't log in with osql. My setup config file is as below.
[Options]
INSTANCENAME=NetSDK
SECURITYMODE=SQL
SAPWD=mypassword
It seems to install and run (green arrow in service bar after giving
it
myservername\NetSDK). Then I try this:
osql -U sa
Password: 'I give mypassword here
[Shared Memory]SQL Server does not exists or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What does this mean? Am I missing something basic? I would really like
to use MSDE, but it seems broken or I just don't have enough
information.
Please cc to jhestess@.yahoo.com. Thanks in advance.
John Estess
El Paso, Texas
This may be a problem with ports or other things. Try these:
"Potential causes of the "SQL Server Does Not Exist or Access Denied" error message"
http://support.microsoft.com/default...06&Product=sql
http://support.microsoft.com/?id=287932
http://support.microsoft.com/default.aspx?kbid=814130
Mark Ferguson
"John Estess" wrote:
> I can't log in with osql. My setup config file is as below.
> [Options]
> INSTANCENAME=NetSDK
> SECURITYMODE=SQL
> SAPWD=mypassword
> It seems to install and run (green arrow in service bar after giving
> it
> myservername\NetSDK). Then I try this:
> osql -U sa
> Password: 'I give mypassword here
> [Shared Memory]SQL Server does not exists or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What does this mean? Am I missing something basic? I would really like
> to use MSDE, but it seems broken or I just don't have enough
> information.
> Please cc to jhestess@.yahoo.com. Thanks in advance.
> John Estess
> El Paso, Texas
>
|||hi John,
"John Estess" <jhestess@.yahoo.com> ha scritto nel messaggio
news:136cf350.0406250942.1417a8a7@.posting.google.c om...
> I can't log in with osql. My setup config file is as below.
> [Options]
> INSTANCENAME=NetSDK
> SECURITYMODE=SQL
> SAPWD=mypassword
> It seems to install and run (green arrow in service bar after giving
> it
> myservername\NetSDK). Then I try this:
> osql -U sa
> Password: 'I give mypassword here
> [Shared Memory]SQL Server does not exists or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What does this mean? Am I missing something basic? I would really like
> to use MSDE, but it seems broken or I just don't have enough
> information.
> Please cc to jhestess@.yahoo.com. Thanks in advance.
> John Estess
> El Paso, Texas
try
c:\>osql -Smyservername\NetSDK -Usa -Pyour_pwd
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql
[Options]
INSTANCENAME=NetSDK
SECURITYMODE=SQL
SAPWD=mypassword
It seems to install and run (green arrow in service bar after giving
it
myservername\NetSDK). Then I try this:
osql -U sa
Password: 'I give mypassword here
[Shared Memory]SQL Server does not exists or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What does this mean? Am I missing something basic? I would really like
to use MSDE, but it seems broken or I just don't have enough
information.
Please cc to jhestess@.yahoo.com. Thanks in advance.
John Estess
El Paso, Texas
This may be a problem with ports or other things. Try these:
"Potential causes of the "SQL Server Does Not Exist or Access Denied" error message"
http://support.microsoft.com/default...06&Product=sql
http://support.microsoft.com/?id=287932
http://support.microsoft.com/default.aspx?kbid=814130
Mark Ferguson
"John Estess" wrote:
> I can't log in with osql. My setup config file is as below.
> [Options]
> INSTANCENAME=NetSDK
> SECURITYMODE=SQL
> SAPWD=mypassword
> It seems to install and run (green arrow in service bar after giving
> it
> myservername\NetSDK). Then I try this:
> osql -U sa
> Password: 'I give mypassword here
> [Shared Memory]SQL Server does not exists or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What does this mean? Am I missing something basic? I would really like
> to use MSDE, but it seems broken or I just don't have enough
> information.
> Please cc to jhestess@.yahoo.com. Thanks in advance.
> John Estess
> El Paso, Texas
>
|||hi John,
"John Estess" <jhestess@.yahoo.com> ha scritto nel messaggio
news:136cf350.0406250942.1417a8a7@.posting.google.c om...
> I can't log in with osql. My setup config file is as below.
> [Options]
> INSTANCENAME=NetSDK
> SECURITYMODE=SQL
> SAPWD=mypassword
> It seems to install and run (green arrow in service bar after giving
> it
> myservername\NetSDK). Then I try this:
> osql -U sa
> Password: 'I give mypassword here
> [Shared Memory]SQL Server does not exists or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What does this mean? Am I missing something basic? I would really like
> to use MSDE, but it seems broken or I just don't have enough
> information.
> Please cc to jhestess@.yahoo.com. Thanks in advance.
> John Estess
> El Paso, Texas
try
c:\>osql -Smyservername\NetSDK -Usa -Pyour_pwd
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql
Thursday, February 16, 2012
Cannot select CSV XML format in Export Format.
Hi,
in my report viewer export format, i only can select 2 type format. one is
pdf another one is excel.
i already check the rsreportserver.config.
the csv xml type no have set to visible false.
but i still can't see the csv and xml
could someone give me some idea to solve the problem,
thank youAre you running Express? or Workgroup ? One or both of these limits the
export types.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ng" <Ng@.discussions.microsoft.com> wrote in message
news:87BDC13A-1521-4EE2-8579-77B3361D2120@.microsoft.com...
> Hi,
> in my report viewer export format, i only can select 2 type format. one is
> pdf another one is excel.
> i already check the rsreportserver.config.
> the csv xml type no have set to visible false.
> but i still can't see the csv and xml
> could someone give me some idea to solve the problem,
> thank you
>
in my report viewer export format, i only can select 2 type format. one is
pdf another one is excel.
i already check the rsreportserver.config.
the csv xml type no have set to visible false.
but i still can't see the csv and xml
could someone give me some idea to solve the problem,
thank youAre you running Express? or Workgroup ? One or both of these limits the
export types.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ng" <Ng@.discussions.microsoft.com> wrote in message
news:87BDC13A-1521-4EE2-8579-77B3361D2120@.microsoft.com...
> Hi,
> in my report viewer export format, i only can select 2 type format. one is
> pdf another one is excel.
> i already check the rsreportserver.config.
> the csv xml type no have set to visible false.
> but i still can't see the csv and xml
> could someone give me some idea to solve the problem,
> thank you
>
Subscribe to:
Posts (Atom)