When I try to connect to my SQL server 2000 which is
installed on WIN 2000 server. The folloeing message box
appears:
"This service doesn't exist as an installed service", also
in some ocasions it will give me error 1060.
This SQL server instance was working ok, till I removed an
application which removed MSDE too.(I have other instances
which work ok)
Did I lose all my other databases in this instance? Is
there anyway that I can recover this instance?
Thanks for help in Advance.
MarkI don't know i should see
but it seems your are trying to login using an SQL account
and not using the integrated windows security.
"Mark" <mpaydar@.yahoo.com> wrote in message
news:1869d01c42055$2fa0c1b0$a601280a@.phx
.gbl...
> When I try to connect to my SQL server 2000 which is
> installed on WIN 2000 server. The folloeing message box
> appears:
> "This service doesn't exist as an installed service", also
> in some ocasions it will give me error 1060.
> This SQL server instance was working ok, till I removed an
> application which removed MSDE too.(I have other instances
> which work ok)
> Did I lose all my other databases in this instance? Is
> there anyway that I can recover this instance?
> Thanks for help in Advance.
> Mark|||-Try connecting to the SQL instance using OSQL or SQL Client tools.
-Look at Control Panel | Services and check if you see the MSSQLSERVER or
MSSQL$<Instance Name> service.
-Search for *.mdf to see if any database files till exist.
Thanks
Deepali
This posting is provided "AS IS" with no warranties, and confers no rightssql
Showing posts with label connect. Show all posts
Showing posts with label connect. Show all posts
Friday, March 30, 2012
I get this error on my SQL server 2000
When I try to connect to my SQL server 2000 which is
installed on WIN 2000 server. The folloeing message box
appears:
"This service doesn't exist as an installed service", also
in some ocasions it will give me error 1060.
This SQL server instance was working ok, till I removed an
application which removed MSDE too.(I have other instances
which work ok)
Did I lose all my other databases in this instance? Is
there anyway that I can recover this instance?
Thanks for help in Advance.
Mark
I don't know i should see
but it seems your are trying to login using an SQL account
and not using the integrated windows security.
"Mark" <mpaydar@.yahoo.com> wrote in message
news:1869d01c42055$2fa0c1b0$a601280a@.phx.gbl...
> When I try to connect to my SQL server 2000 which is
> installed on WIN 2000 server. The folloeing message box
> appears:
> "This service doesn't exist as an installed service", also
> in some ocasions it will give me error 1060.
> This SQL server instance was working ok, till I removed an
> application which removed MSDE too.(I have other instances
> which work ok)
> Did I lose all my other databases in this instance? Is
> there anyway that I can recover this instance?
> Thanks for help in Advance.
> Mark
|||-Try connecting to the SQL instance using OSQL or SQL Client tools.
-Look at Control Panel | Services and check if you see the MSSQLSERVER or
MSSQL$<Instance Name> service.
-Search for *.mdf to see if any database files till exist.
Thanks
Deepali
This posting is provided "AS IS" with no warranties, and confers no rights
installed on WIN 2000 server. The folloeing message box
appears:
"This service doesn't exist as an installed service", also
in some ocasions it will give me error 1060.
This SQL server instance was working ok, till I removed an
application which removed MSDE too.(I have other instances
which work ok)
Did I lose all my other databases in this instance? Is
there anyway that I can recover this instance?
Thanks for help in Advance.
Mark
I don't know i should see
but it seems your are trying to login using an SQL account
and not using the integrated windows security.
"Mark" <mpaydar@.yahoo.com> wrote in message
news:1869d01c42055$2fa0c1b0$a601280a@.phx.gbl...
> When I try to connect to my SQL server 2000 which is
> installed on WIN 2000 server. The folloeing message box
> appears:
> "This service doesn't exist as an installed service", also
> in some ocasions it will give me error 1060.
> This SQL server instance was working ok, till I removed an
> application which removed MSDE too.(I have other instances
> which work ok)
> Did I lose all my other databases in this instance? Is
> there anyway that I can recover this instance?
> Thanks for help in Advance.
> Mark
|||-Try connecting to the SQL instance using OSQL or SQL Client tools.
-Look at Control Panel | Services and check if you see the MSSQLSERVER or
MSSQL$<Instance Name> service.
-Search for *.mdf to see if any database files till exist.
Thanks
Deepali
This posting is provided "AS IS" with no warranties, and confers no rights
Wednesday, March 28, 2012
I dont know how to connect with Ms Sql
Hello,
I am new at asp.net. I want to design a website using asp.net as frontend and sql database as backend. I am able to connect and add,update as well delete records when I use MsAcess and Asp.net using the following connection strings...
**********
sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & server.mappath("db1.mdb"))
dbconn.Open()
sql="SELECT * FROM table1"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
data1.DataSource=dbread
data1.DataBind()
dbread.Close()
dbconn.Close()
end sub
**********
But I don't know how to connect with Ms Sql.
I have MS SQL Server 2003 in my computer aleady Installed.
Please Tell me the exact code or procedure to make connection with MS SQL Server.
HELP ME!!!!
The equivelent code for connecting to SQL server is:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim dbconn As SqlConnection = Nothing
Dim dbread As SqlDataReader = Nothing
Try
dbconn = New SqlConnection("server=;uid=;password=;database=;")
Dim sql As String = "SELECT * FROM table1"
Dim dbcomm As New SqlCommand(sql, dbconn)
dbconn.Open()
dbread = dbcomm.ExecuteReader()
data1.DataBind()
Finally
If Not dbconn Is Nothing Then
If dbconn.State = ConnectionState.Open Then
dbconn.Close()
End If
End If
If Not dbread Is Nothing Then
If Not dbread.IsClosed Then
dbread.Close()
End If
End If
End Try
End Sub
HTH,
Ryan
Monday, March 26, 2012
I changed my windows password and now I cannot connect to SQL Server on my development mac
I changed the login password on my computer today, and now I cannot connect to the SQL Server instance I have on that same machine. I am using Windows Authentication.
I would think that, if I can log on to my computer, I would be able to connect to the database, since I have been "authenticated" by windows but, that does not appear to be the case.
Can anyone offer any advice?
Thanks in advance for any help you can provide.
When i doubt, restart
I figured it out.
If anyone is interested...
I had to manually go to Administrative Tools > Services and choose (double-click) SQL Server (MSSQLSERVER). Then go to the Log On tab and change the password there. I did the same for SQL Server Agent (MSSQLSERVER). I haven't done any of the other SQL Server - related services on my machine. I will do those as needed, I guess, cause I am not using them yet.
I hope this helps someone.
Ah, you're using your Windows login to run the SQL Server service. Generally not a good idea on a server, for the reason you found, but it is probably okay on a development machine.
Glad you figured it out!
Don
|||Ahh...Thats the start up account. So your SQL Server is set up to start as a "Local Account". Generally its a good practice to use a Windows account that is not part of windows admnistrator group. Check out books on line for more info about SQL Server agent and the security model.
sqlI can't view the list of databases on remote site
I have been asked to work on a remote site. I started my EM and tried to
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folders I
see various items. For example, Security/Login lists lots of login entries.
Just to see what would happen I right-clicked on Databases and clicked All
Tasks/Backup Database and got a list of databases that I was NOT allowed to
backup! But, still no list of databases.
Any ideas?
BTW, I am using SQL Server 2000 EM.
TIA,
Larry WoodsHi,
Could you refresh the database option and see.
As well as login to Query analyzer and execute the below command to get the
databases:-
SP_HELPDB
For backing up try
BACKUP Database <dbanme> to disk='d:\backup\dbname_Oct16.bak' with
INIT,STATS=5
If you get a permission issue contact the database admin.
Thanks
Hari
SQL Server MVP
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Please try to connect usin Query Analyzer and execute the following
use master
go
select *
from information_schema.schemata
select *
from sysdatabases
This will enable you to display all databases on a server
--
Best Regards
Krystian Zieja / mob
"lwoods" wrote:
> I have been asked to work on a remote site. I started my EM and tried to
> connect to the SQL server on the remote site. I connected just fine (server
> had userid/password). But when I open the "Databases" folder I get a "(no
> items)" instead of a list of databases. BUT, when I view other folders I
> see various items. For example, Security/Login lists lots of login entries.
> Just to see what would happen I right-clicked on Databases and clicked All
> Tasks/Backup Database and got a list of databases that I was NOT allowed to
> backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
>|||Hi
See answer in .programming. Please do not multi-post.
John
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Will do...
Please note that I DON'T usually do this, but I needed an answer FAST so I
tried to connect to multiple groups. I understand the problem...
Larry
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23SZCJEk0FHA.2600@.TK2MSFTNGP10.phx.gbl...
> Hi
> See answer in .programming. Please do not multi-post.
>
> John
> "lwoods" <larry@.lwoods.com> wrote in message
> news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>>I have been asked to work on a remote site. I started my EM and tried to
>>connect to the SQL server on the remote site. I connected just fine
>>(server had userid/password). But when I open the "Databases" folder I
>>get a "(no items)" instead of a list of databases. BUT, when I view other
>>folders I see various items. For example, Security/Login lists lots of
>>login entries. Just to see what would happen I right-clicked on Databases
>>and clicked All Tasks/Backup Database and got a list of databases that I
>>was NOT allowed to backup! But, still no list of databases.
>> Any ideas?
>>
>> BTW, I am using SQL Server 2000 EM.
>> TIA,
>> Larry Woods
>sql
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folders I
see various items. For example, Security/Login lists lots of login entries.
Just to see what would happen I right-clicked on Databases and clicked All
Tasks/Backup Database and got a list of databases that I was NOT allowed to
backup! But, still no list of databases.
Any ideas?
BTW, I am using SQL Server 2000 EM.
TIA,
Larry WoodsHi,
Could you refresh the database option and see.
As well as login to Query analyzer and execute the below command to get the
databases:-
SP_HELPDB
For backing up try
BACKUP Database <dbanme> to disk='d:\backup\dbname_Oct16.bak' with
INIT,STATS=5
If you get a permission issue contact the database admin.
Thanks
Hari
SQL Server MVP
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Please try to connect usin Query Analyzer and execute the following
use master
go
select *
from information_schema.schemata
select *
from sysdatabases
This will enable you to display all databases on a server
--
Best Regards
Krystian Zieja / mob
"lwoods" wrote:
> I have been asked to work on a remote site. I started my EM and tried to
> connect to the SQL server on the remote site. I connected just fine (server
> had userid/password). But when I open the "Databases" folder I get a "(no
> items)" instead of a list of databases. BUT, when I view other folders I
> see various items. For example, Security/Login lists lots of login entries.
> Just to see what would happen I right-clicked on Databases and clicked All
> Tasks/Backup Database and got a list of databases that I was NOT allowed to
> backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
>|||Hi
See answer in .programming. Please do not multi-post.
John
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Will do...
Please note that I DON'T usually do this, but I needed an answer FAST so I
tried to connect to multiple groups. I understand the problem...
Larry
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23SZCJEk0FHA.2600@.TK2MSFTNGP10.phx.gbl...
> Hi
> See answer in .programming. Please do not multi-post.
>
> John
> "lwoods" <larry@.lwoods.com> wrote in message
> news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>>I have been asked to work on a remote site. I started my EM and tried to
>>connect to the SQL server on the remote site. I connected just fine
>>(server had userid/password). But when I open the "Databases" folder I
>>get a "(no items)" instead of a list of databases. BUT, when I view other
>>folders I see various items. For example, Security/Login lists lots of
>>login entries. Just to see what would happen I right-clicked on Databases
>>and clicked All Tasks/Backup Database and got a list of databases that I
>>was NOT allowed to backup! But, still no list of databases.
>> Any ideas?
>>
>> BTW, I am using SQL Server 2000 EM.
>> TIA,
>> Larry Woods
>sql
Friday, March 23, 2012
I cant make new SQL Server Registration
When I regratrate, it occurs that
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?Hi, Check the User name and the password.
one more thing ..check whether the sql server is accessible from ur machine or not. use the ping command to check it.
cheers
gola munjal
Originally posted by yajai
When I regratrate, it occurs that
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?|||Make sure to have similar netlibs as default on server and client.
Try connecting with TCP/IP.|||when i ping host, result is
Pinging 216.58.174.179 with 32 bytes of data:
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Ping statistics for 216.58.174.179:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)
what does it mean?|||How I connect TCP/IP?|||If the PING is not successful then how can you connect?
Take a help of NETWORK Admin to resolve the connectivity first.
Refer to this KBA (http://support.microsoft.com/default.aspx?scid=/support/sql/content/connect/ClientIP.asp) for more information.
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?Hi, Check the User name and the password.
one more thing ..check whether the sql server is accessible from ur machine or not. use the ping command to check it.
cheers
gola munjal
Originally posted by yajai
When I regratrate, it occurs that
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?|||Make sure to have similar netlibs as default on server and client.
Try connecting with TCP/IP.|||when i ping host, result is
Pinging 216.58.174.179 with 32 bytes of data:
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Ping statistics for 216.58.174.179:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)
what does it mean?|||How I connect TCP/IP?|||If the PING is not successful then how can you connect?
Take a help of NETWORK Admin to resolve the connectivity first.
Refer to this KBA (http://support.microsoft.com/default.aspx?scid=/support/sql/content/connect/ClientIP.asp) for more information.
i can't login to sqlserver with a username and a password but works with NT integrated security
hi
i have created a username and a password in sqlserver 2000 from logins in Enterprise manager
and i permit him to the database i need to connect to ..
and i check all server roles for that user and i make sqlserver authentication for him with a password and then i goto the udl file to connect to that database using that user it fails !!
and says
you are goodsql
i have created a username and a password in sqlserver 2000 from logins in Enterprise manager
and i permit him to the database i need to connect to ..
and i check all server roles for that user and i make sqlserver authentication for him with a password and then i goto the udl file to connect to that database using that user it fails !!
and says"login failed for that user 'myusername' reason not associated with a trusted sqlserver connection"
while i use NT integrated security it works well
so how can i connect to sqlserver using a username and a password
thanks in advance
Hi,
You need to make sure that SQL Server Authentication is set to "SQL Server and Windows Authentication mode". You do this by right clicking on the server name in Management Studio, selecting properties and then clicking on the Security page.
By default SQL Server is installed to use Windows Authentication mode only.
Cheers
Jeff
you are goodsql
i can't login to sqlserver with a username and a password but works with NT integrated secu
hi
i have created a username and a password in sqlserver 2000 from logins in Enterprise manager
and i permit him to the database i need to connect to ..
and i check all server roles for that user and i make sqlserver authentication for him with a password and then i goto the udl file to connect to that database using that user it fails !!and says
you are good
i have created a username and a password in sqlserver 2000 from logins in Enterprise manager
and i permit him to the database i need to connect to ..
and i check all server roles for that user and i make sqlserver authentication for him with a password and then i goto the udl file to connect to that database using that user it fails !!
and says"login failed for that user 'myusername' reason not associated with a trusted sqlserver connection"
while i use NT integrated security it works well
so how can i connect to sqlserver using a username and a password
thanks in advance
Hi,
You need to make sure that SQL Server Authentication is set to "SQL Server and Windows Authentication mode". You do this by right clicking on the server name in Management Studio, selecting properties and then clicking on the Security page.
By default SQL Server is installed to use Windows Authentication mode only.
Cheers
Jeff
you are good
I cant execute my asp.net application with IIS 5.0
Hi, please i have a problem, i can't execute my asp.net application with IIS 5.0? i have a message indicating that MYSERVER\ASPNET can't connect, and that arrive when trying connect to the database under SQL Server 2000. you have to know that my application work very well with webserver of WebMatrix. Web Matrix Project : version 0.6 .Net Framework 1.1 Thank you. |
I CAN'T CONNECT TO MY SQLSERVER 2000 USING A VPN THROUGH A FIREWAL
I am trying to connect to my Sql Server 2000 with Windows 2003 server, using
a VPN.
In my firewall I opened port 1433 and 1434.
I setup mi Client Network Utility:
- General: TCP/IP ENABLED
- Alias: TCP/IP, SERVER IP, AND PORT 1433
If I ping to my server it response very fast (400ms or less), but I cannot
connect using Query Analyzer.
Using the same VPN I can connect to my Unix server using Telnet.
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default...&Product=sql2k
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"RAFAEL ORELLANA" <RAFAEL ORELLANA@.discussions.microsoft.com> wrote in
message news:BB73F7C1-416C-49E6-8F41-0578D685079B@.microsoft.com...
> I am trying to connect to my Sql Server 2000 with Windows 2003 server,
using
> a VPN.
> In my firewall I opened port 1433 and 1434.
> I setup mi Client Network Utility:
> - General: TCP/IP ENABLED
> - Alias: TCP/IP, SERVER IP, AND PORT 1433
> If I ping to my server it response very fast (400ms or less), but I cannot
> connect using Query Analyzer.
> Using the same VPN I can connect to my Unix server using Telnet.
>
a VPN.
In my firewall I opened port 1433 and 1434.
I setup mi Client Network Utility:
- General: TCP/IP ENABLED
- Alias: TCP/IP, SERVER IP, AND PORT 1433
If I ping to my server it response very fast (400ms or less), but I cannot
connect using Query Analyzer.
Using the same VPN I can connect to my Unix server using Telnet.
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default...&Product=sql2k
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"RAFAEL ORELLANA" <RAFAEL ORELLANA@.discussions.microsoft.com> wrote in
message news:BB73F7C1-416C-49E6-8F41-0578D685079B@.microsoft.com...
> I am trying to connect to my Sql Server 2000 with Windows 2003 server,
using
> a VPN.
> In my firewall I opened port 1433 and 1434.
> I setup mi Client Network Utility:
> - General: TCP/IP ENABLED
> - Alias: TCP/IP, SERVER IP, AND PORT 1433
> If I ping to my server it response very fast (400ms or less), but I cannot
> connect using Query Analyzer.
> Using the same VPN I can connect to my Unix server using Telnet.
>
Wednesday, March 21, 2012
i can't connect with the MSDE instance from another computer
I've installed a MSDE in one computer and i can access the
data without problems from the same computer , but if i
try to connect to the MSDE from another computer in the
same network , the instance doesn't appear. I tried from
almost 3 computers but i can't connect.
What i'm doing wrong?
Jorge,
If you installed the latest version the network protocols are probably
disabled (the default setting). Use svrnetcn.exe in the Binn folder under
your sql server directory to enable TCP/IP and things should work again. If
the machine with MSDE has a firewall make sure that the appropriate ports
can pass through the firewall (normally 1433). Use Properties on the
enabled TCP protocol to see the port used.
Ron Allen
"Jorge Lozano" <j.lozano@.initron20.com> wrote in message
news:07f001c49a51$94f2b8e0$a601280a@.phx.gbl...
> I've installed a MSDE in one computer and i can access the
> data without problems from the same computer , but if i
> try to connect to the MSDE from another computer in the
> same network , the instance doesn't appear. I tried from
> almost 3 computers but i can't connect.
> What i'm doing wrong?
data without problems from the same computer , but if i
try to connect to the MSDE from another computer in the
same network , the instance doesn't appear. I tried from
almost 3 computers but i can't connect.
What i'm doing wrong?
Jorge,
If you installed the latest version the network protocols are probably
disabled (the default setting). Use svrnetcn.exe in the Binn folder under
your sql server directory to enable TCP/IP and things should work again. If
the machine with MSDE has a firewall make sure that the appropriate ports
can pass through the firewall (normally 1433). Use Properties on the
enabled TCP protocol to see the port used.
Ron Allen
"Jorge Lozano" <j.lozano@.initron20.com> wrote in message
news:07f001c49a51$94f2b8e0$a601280a@.phx.gbl...
> I've installed a MSDE in one computer and i can access the
> data without problems from the same computer , but if i
> try to connect to the MSDE from another computer in the
> same network , the instance doesn't appear. I tried from
> almost 3 computers but i can't connect.
> What i'm doing wrong?
I cant connect to sql server from a computer on my network
I am trying to log in to sql server on another desktop on my network.
When I open sql management studio I am able to find the server however
when I try to log in I am unable to connect. I have gone into the
configuration tool and enabled tcp/ip and named pipes remote
connections on the computer that is acting as the server but I still
get an error when I try to connect. How do I enable it so that I can
log onto the server on the other computer.npbaker1@.neo.rr.com wrote:
> I am trying to log in to sql server on another desktop on my network.
> When I open sql management studio I am able to find the server however
> when I try to log in I am unable to connect. I have gone into the
> configuration tool and enabled tcp/ip and named pipes remote
> connections on the computer that is acting as the server but I still
> get an error when I try to connect. How do I enable it so that I can
> log onto the server on the other computer.
>
Hi
What is the error message you get?
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
When I open sql management studio I am able to find the server however
when I try to log in I am unable to connect. I have gone into the
configuration tool and enabled tcp/ip and named pipes remote
connections on the computer that is acting as the server but I still
get an error when I try to connect. How do I enable it so that I can
log onto the server on the other computer.npbaker1@.neo.rr.com wrote:
> I am trying to log in to sql server on another desktop on my network.
> When I open sql management studio I am able to find the server however
> when I try to log in I am unable to connect. I have gone into the
> configuration tool and enabled tcp/ip and named pipes remote
> connections on the computer that is acting as the server but I still
> get an error when I try to connect. How do I enable it so that I can
> log onto the server on the other computer.
>
Hi
What is the error message you get?
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
I cant connect to sql server from a computer on my network
I am trying to log in to sql server on another desktop on my network.
When I open sql management studio I am able to find the server however
when I try to log in I am unable to connect. I have gone into the
configuration tool and enabled tcp/ip and named pipes remote
connections on the computer that is acting as the server but I still
get an error when I try to connect. How do I enable it so that I can
log onto the server on the other computer.npbaker1@.neo.rr.com wrote:
> I am trying to log in to sql server on another desktop on my network.
> When I open sql management studio I am able to find the server however
> when I try to log in I am unable to connect. I have gone into the
> configuration tool and enabled tcp/ip and named pipes remote
> connections on the computer that is acting as the server but I still
> get an error when I try to connect. How do I enable it so that I can
> log onto the server on the other computer.
>
Hi
What is the error message you get?
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||Try the usual suspects:
1. Check whether the instance is running,
2. Try to connect to it locally,
3. Ping the other server from this machine to make sure you can reach it,
4. Try to connect to it using the IP address followed by the port number
after a comma
The messages or error messages from these tests should give you some clue.
Linchi
"npbaker1@.neo.rr.com" wrote:
> I am trying to log in to sql server on another desktop on my network.
> When I open sql management studio I am able to find the server however
> when I try to log in I am unable to connect. I have gone into the
> configuration tool and enabled tcp/ip and named pipes remote
> connections on the computer that is acting as the server but I still
> get an error when I try to connect. How do I enable it so that I can
> log onto the server on the other computer.
>
When I open sql management studio I am able to find the server however
when I try to log in I am unable to connect. I have gone into the
configuration tool and enabled tcp/ip and named pipes remote
connections on the computer that is acting as the server but I still
get an error when I try to connect. How do I enable it so that I can
log onto the server on the other computer.npbaker1@.neo.rr.com wrote:
> I am trying to log in to sql server on another desktop on my network.
> When I open sql management studio I am able to find the server however
> when I try to log in I am unable to connect. I have gone into the
> configuration tool and enabled tcp/ip and named pipes remote
> connections on the computer that is acting as the server but I still
> get an error when I try to connect. How do I enable it so that I can
> log onto the server on the other computer.
>
Hi
What is the error message you get?
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||Try the usual suspects:
1. Check whether the instance is running,
2. Try to connect to it locally,
3. Ping the other server from this machine to make sure you can reach it,
4. Try to connect to it using the IP address followed by the port number
after a comma
The messages or error messages from these tests should give you some clue.
Linchi
"npbaker1@.neo.rr.com" wrote:
> I am trying to log in to sql server on another desktop on my network.
> When I open sql management studio I am able to find the server however
> when I try to log in I am unable to connect. I have gone into the
> configuration tool and enabled tcp/ip and named pipes remote
> connections on the computer that is acting as the server but I still
> get an error when I try to connect. How do I enable it so that I can
> log onto the server on the other computer.
>
I can't connect to SQL server 2005 with Management studio express
Hi all,
my server is on internet and can be accessed by sqlb2.webcontrolcenter.com to my hoster.
I subscribe for SQL server 2005
I try to connect to sql server 2005 via Management studio express and visual web developper express without success. i got this error below with both:
Cannot connect to sqlb2.webcontrolcenter.com
a connectionmwas successfully established with the server, but then an error occured during the login process. (Provider: TCP provider, error: 0 -The specified network name is no longer available )
(Microsoft sql server, error 64)
thank's for your help
These errors indicate that the connection between the client and SQL Server was broken for some reason while SQL Server was writing data to the client. You mention that you are accessing the server across the internet, so part of the issue may be routing/firewall rules/devices between you and your provider...if you are able to get through to the server, you may not be able to get data back from the server or vice-versa.
Can you telnet to the TCP port that SQL Server is listening on? i.e. telnet to the IP and port combination you are trying to connect to?
Additionally, ensure your SQL Server is configured to allow remote connections.
This is typcially more of a transport-level issue than SQL Server error (in this case, TCP for example)...
|||Hello Chad Boyd,
it was my firewall , i put it off and now my connection is working
Thank's for your response
I CAN'T CONNECT TO MY SQLSERVER 2000 USING A VPN THROUGH A FIREWAL
I am trying to connect to my Sql Server 2000 with Windows 2003 server, using
a VPN.
In my firewall I opened port 1433 and 1434.
I setup mi Client Network Utility:
- General: TCP/IP ENABLED
- Alias: TCP/IP, SERVER IP, AND PORT 1433
If I ping to my server it response very fast (400ms or less), but I cannot
connect using Query Analyzer.
Using the same VPN I can connect to my Unix server using Telnet.
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default...&Product=sql2k
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"RAFAEL ORELLANA" <RAFAEL ORELLANA@.discussions.microsoft.com> wrote in
message news:BB73F7C1-416C-49E6-8F41-0578D685079B@.microsoft.com...
> I am trying to connect to my Sql Server 2000 with Windows 2003 server,
using
> a VPN.
> In my firewall I opened port 1433 and 1434.
> I setup mi Client Network Utility:
> - General: TCP/IP ENABLED
> - Alias: TCP/IP, SERVER IP, AND PORT 1433
> If I ping to my server it response very fast (400ms or less), but I cannot
> connect using Query Analyzer.
> Using the same VPN I can connect to my Unix server using Telnet.
>
a VPN.
In my firewall I opened port 1433 and 1434.
I setup mi Client Network Utility:
- General: TCP/IP ENABLED
- Alias: TCP/IP, SERVER IP, AND PORT 1433
If I ping to my server it response very fast (400ms or less), but I cannot
connect using Query Analyzer.
Using the same VPN I can connect to my Unix server using Telnet.
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default...&Product=sql2k
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"RAFAEL ORELLANA" <RAFAEL ORELLANA@.discussions.microsoft.com> wrote in
message news:BB73F7C1-416C-49E6-8F41-0578D685079B@.microsoft.com...
> I am trying to connect to my Sql Server 2000 with Windows 2003 server,
using
> a VPN.
> In my firewall I opened port 1433 and 1434.
> I setup mi Client Network Utility:
> - General: TCP/IP ENABLED
> - Alias: TCP/IP, SERVER IP, AND PORT 1433
> If I ping to my server it response very fast (400ms or less), but I cannot
> connect using Query Analyzer.
> Using the same VPN I can connect to my Unix server using Telnet.
>
I CAN'T CONNECT TO MY SQLSERVER 2000 USING A VPN THROUGH A FIREWAL
I am trying to connect to my Sql Server 2000 with Windows 2003 server, using
a VPN.
In my firewall I opened port 1433 and 1434.
I setup mi Client Network Utility:
- General: TCP/IP ENABLED
- Alias: TCP/IP, SERVER IP, AND PORT 1433
If I ping to my server it response very fast (400ms or less), but I cannot
connect using Query Analyzer.
Using the same VPN I can connect to my Unix server using Telnet.INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/defaul...2&Product=sql2k
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"RAFAEL ORELLANA" <RAFAEL ORELLANA@.discussions.microsoft.com> wrote in
message news:BB73F7C1-416C-49E6-8F41-0578D685079B@.microsoft.com...
> I am trying to connect to my Sql Server 2000 with Windows 2003 server,
using
> a VPN.
> In my firewall I opened port 1433 and 1434.
> I setup mi Client Network Utility:
> - General: TCP/IP ENABLED
> - Alias: TCP/IP, SERVER IP, AND PORT 1433
> If I ping to my server it response very fast (400ms or less), but I cannot
> connect using Query Analyzer.
> Using the same VPN I can connect to my Unix server using Telnet.
>sql
a VPN.
In my firewall I opened port 1433 and 1434.
I setup mi Client Network Utility:
- General: TCP/IP ENABLED
- Alias: TCP/IP, SERVER IP, AND PORT 1433
If I ping to my server it response very fast (400ms or less), but I cannot
connect using Query Analyzer.
Using the same VPN I can connect to my Unix server using Telnet.INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/defaul...2&Product=sql2k
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"RAFAEL ORELLANA" <RAFAEL ORELLANA@.discussions.microsoft.com> wrote in
message news:BB73F7C1-416C-49E6-8F41-0578D685079B@.microsoft.com...
> I am trying to connect to my Sql Server 2000 with Windows 2003 server,
using
> a VPN.
> In my firewall I opened port 1433 and 1434.
> I setup mi Client Network Utility:
> - General: TCP/IP ENABLED
> - Alias: TCP/IP, SERVER IP, AND PORT 1433
> If I ping to my server it response very fast (400ms or less), but I cannot
> connect using Query Analyzer.
> Using the same VPN I can connect to my Unix server using Telnet.
>sql
I cant connect to my SQL database using Enterprise Manager :(
Hello,
I am trying to solve this problem for the past 1.5 weeks and it is driving me crazy :(
I can't connect to my SQL database using Enterprise Manager, Query Analyzer, Visual Studio 2003 .NET or a .aspx that I created for testing.. it runs perfectly on my domain but it doesnt work on my computer, on the browser I get this message: SQL Server unavailable or access denied. It is the same message I get when I try connecting to my db using EM, QA, VS.NET etc :(
I can ping my sql domain, so I know I have access to it and it is working.. I can successfully connect to my personal SQL server running on my machine. (SQL Server Personal Edition running on Windows XP )
I tried doing everything I could,
I already selected TCP/IP as my client only protocol;
I tried installing the lastest MDAC (v 2.8);
I tried every other port on my TCP/IP client setup like 14333 or 11433 or 11143 etc;
I tried every other port on the alias I set for my sql address;
I tried downloading the evaluation version of MS SQL2000 and updating it to SP3;
I tried reinstalling several times my MS SQL2000 (I use the personal edition on my windows XP) and updating it to SP3;
I tried connecting to my sql address domain and directly to its IP;
And I tried a lot more resolutions that I can't remember right now, but it didn't work :(
I've been searching all forums/google etc looking for someone with my problem but I still didnt, everyone who had a problem connecting to their DB using EM or QA resolved it by doing "this or that", I did exactly the same "this or that" on my computer/config and it didn't resolve my problem. :(
What am I doing wrong? I can't connect to my database from my personal computer :(
I have never used enterprise manager before, so I don't know if it is a problem on my personal computer or on my sql server address on internet.. Is there anyway to find a free test ms sql database with like 1mb just to try and find out if I can connect to a sql database at all using EM or if the problem is here on my computer?
Thanks in advance for any help,
XandeHI ,
I had similar problems , are you going through a firewall? also did you try typing in the ip addy instead of the server name?
Burner|||Hello,
Yes, I tried typing the IP and I already opened the port 1433 on my router DSL.. :(
Thanks|||HI ,
do you guys use port 1433, try port 2433.Do you guys connect through a firewall if yes type in the server on which the firewall resides IP...and port 2433 and see ...
I am trying to solve this problem for the past 1.5 weeks and it is driving me crazy :(
I can't connect to my SQL database using Enterprise Manager, Query Analyzer, Visual Studio 2003 .NET or a .aspx that I created for testing.. it runs perfectly on my domain but it doesnt work on my computer, on the browser I get this message: SQL Server unavailable or access denied. It is the same message I get when I try connecting to my db using EM, QA, VS.NET etc :(
I can ping my sql domain, so I know I have access to it and it is working.. I can successfully connect to my personal SQL server running on my machine. (SQL Server Personal Edition running on Windows XP )
I tried doing everything I could,
I already selected TCP/IP as my client only protocol;
I tried installing the lastest MDAC (v 2.8);
I tried every other port on my TCP/IP client setup like 14333 or 11433 or 11143 etc;
I tried every other port on the alias I set for my sql address;
I tried downloading the evaluation version of MS SQL2000 and updating it to SP3;
I tried reinstalling several times my MS SQL2000 (I use the personal edition on my windows XP) and updating it to SP3;
I tried connecting to my sql address domain and directly to its IP;
And I tried a lot more resolutions that I can't remember right now, but it didn't work :(
I've been searching all forums/google etc looking for someone with my problem but I still didnt, everyone who had a problem connecting to their DB using EM or QA resolved it by doing "this or that", I did exactly the same "this or that" on my computer/config and it didn't resolve my problem. :(
What am I doing wrong? I can't connect to my database from my personal computer :(
I have never used enterprise manager before, so I don't know if it is a problem on my personal computer or on my sql server address on internet.. Is there anyway to find a free test ms sql database with like 1mb just to try and find out if I can connect to a sql database at all using EM or if the problem is here on my computer?
Thanks in advance for any help,
XandeHI ,
I had similar problems , are you going through a firewall? also did you try typing in the ip addy instead of the server name?
Burner|||Hello,
Yes, I tried typing the IP and I already opened the port 1433 on my router DSL.. :(
Thanks|||HI ,
do you guys use port 1433, try port 2433.Do you guys connect through a firewall if yes type in the server on which the firewall resides IP...and port 2433 and see ...
I cant connect to my local sql server express db. Please help
Hello,
I need help to connect to my local sql express db in visual studio 2003 in vb.
It currently works with the production db information and I need to test a few things, So i'd like to point it to the local db.
It works this way:
Const CONN_STRING = "server=johndoe;user id=john;password=doe;database=johnd"
Dim conn As SqlConnection = New SqlConnection(Me.CONN_STRING)
conn.Open()
I want to point it to my local db and it doesn't connect.
Dim connectionString As String = "Data Source={myusername\SQLEXPRESS};Initial Catalog=johnd;Trusted_Connection=yes"
Dim conn As SqlConnection = New SqlConnection(connectionString)
Try
conn.Open()
Catch ex As Exception
Response.Write(ex.ToString())
End Try
and even that doesn't work.
When i go to my sql server 2005, it says
MYUSERNAME\SQLEXPRESS (SQL SERVER 9.0.3042 - theworknetwork\myusername
what am i doing wrong ?
Thanks.
You can try two things:
1) If you are an administrator on your local computer, then make sure that your user ID is in the Administrators group and then make that the Administrators group has access to the SQLEXPRESS instance. Change the user ID used by the SQL Server Management Tool with your local machine login, not your network login. If this doesn't work, replace it with the local machine Administrator account.
2) Instead of using Windows authorizations, use SQL Server authorizations. Create a new user in SQL Server specifically for your database. Make this user the dbo. Then use this user name with password in your ConnectionString.
At times, I have issues with Windows users because the passwords are different across the various computers. This has not been the case with SQL Server credentials, which I usually prefer.
Also, try using Integrated_Security in place of Trusted_Connection in the ConnectionString.
|||Heres what I've tried. I went to that db (johnd), went to the security>users> and there is already a user called dbo
I tried doing Integrated_Security like you said and i got an error saying that is an invalid key. So here is what I have and it still doesn't work.
"Data Source={myusername\SQLEXPRESS};Initial Catalog=intranet;Trusted_Connection=yes;user id=dbo; password=dbo"
Any ideas?
Can you please try with the following connection string if you are using NT Authentication:
Data Source={localmachine\SQLEXPRESS};Initial Catalog=intranet;Trusted_Connection=yes;
If you are using SQL Server User please try with the following connection string:
Data Source={localmachine\SQLEXPRESS};Initial Catalog=intranet;user id=<local sql server user>; password=<password>
Please make sure that you are changing the bold string with appropriate values.
Following URL provides you the steps to create the user:
http://www.microsoft.com/technet/prodtechnol/sql/2005/mgsqlexpwssmse.mspx
|||I am in microsoft sql server managemen studio Object explorer (on left)
The very first item shows SDAVID\SQLEXPRESS
underneath that i have my database intranet
I then went to security > users [right click] > New User
Under Database User - New,
User Name: SDAVID
Login name
a new window came for Select Login and i found SDAVID [hit okay.]
* so now it shows User name: SDAVID
and login name shows SDAVID
under schemas owned by this user, I choose db_owner and db_securityadmin
under database membership i choose db_owner and db_securityadmin
Now under the code, here is what i have...
Const dbstring = "Data Source={SDAVID\SQLEXPRESS};Initial Catalog=intranet;user id=<sdavid>; password=<sdavid>"
Public Function testConnection()
Dim connectionString As String = "Data Source={SDAVID\SQLEXPRESS};Initial Catalog=intranet;user id=<sdavid>; password=<sdavid>"
Dim conn As SqlConnection = New SqlConnection(ConnectionString)
Dim cmd As SqlCommand = New SqlCommand("selec * from tblUsers", conn)
cmd.CommandType = CommandType.Text
Try
conn.Open()
Catch ex As Exception
Response.Write(ex.ToString())
Finally
conn.Close()
End Try
this generates the following error:
sqlException: Sql server does not exists or access denied.
thanks.
|||Can you please use the following modified connection string:
Const dbstring = "Data Source=SDAVID\SQLEXPRESS;Initial Catalog=intranet;user id=sdavid; password=sdavid"
|||Thank you. that did it! ..
Data Source=SDAVID\SQLEXPRESS;Initial Catalog=intranet;Trusted_Connection=yes;
Hey Sri,
I tried it your way with specifying username and password and that did not work. Do you know why this could be ?
in Micrososft Sql Server Mangement Studio, i went to the db, Security > USers and created a user called sdavid with sdavid. I gave the user db_datareader and db_owner an under database roles membership gave it db_owner... i'd like to get the app working sql sever authhentication.
thanks.
I cant connect to my Local DataBase please help...
DBconn.cs
private DBConn()
{
//
// TODO: 在這裡加入建構函式的程式碼
//
this.Server=Property.getProperty("DBServer");
this.port=int.Parse(Property.getProperty("DBPort"));
this.User=Property.getProperty("DBUser");
this.Pwd=Property.getProperty("DBPwd");
this.db=Property.getProperty("DBDatabase");
this.ConnectionString="server=" + this.Server+","+this.port+";database="+this.db+";uid="+this.User+";pwd="+this.Pwd+";Connect Timeout=60";
}
--------------------------------
propetry.config
<property name="DBServer" value="127.0.0.1" />
<property name="DBPort" value="1433" />
<property name="DBDatabase" value="CSLC" />
<property name="DBUser" value="CSLCUser" />
<property name="DBPwd" value="resslc" />
I use this way to call my connecting string , but I can't connect to my local DataBase , I trid to modify the propetry.config to coneect to other DataBase on other Server it works
only when Connecting with my Local DataBase , it not work...
this problem have been troble me more than 3 weeks... ask many people no one can resolve this problem...
when I am at home . I can't work... because I can't connect to the Server when I'm in office..
pleaes help... thank you very much
Change your DBServer property to(local).
I have tried this way before
the property.config was looks like below
propetry.config
<property name="DBServer" value="local" />
<property name="DBPort" value="1433" />
<property name="DBDatabase" value="CSLC" />
<property name="DBUser" value="CSLCUser" />
<property name="DBPwd" value="resslc" />
it doesn't work as well... please help..
|||It should be
<property name="DBServer" value="(local)" /> <property name="DBPort" value="1433" /> <property name="DBDatabase" value="CSLC" /> <property name="DBUser" value="CSLCUser" /> <property name="DBPwd" value="resslc" />|||
yes, I did
now it looks like
<property name="DBServer" value="(local)" />
<property name="DBPort" value="1433" />
<property name="DBDatabase" value="CSLC" />
<property name="DBUser" value="CSLCUser" />
<property name="DBPwd" value="resslc" />
it still fail when Coneecting with DB... is it possible wrong SQL Server Setting? like security problem?
can you teach me how to check if problem is from SQL Server Setting please? thank you very much
|||
Start off with going to http://www.connectionstrings.com to get a "good" connection string for your application. Verify that you can connect to the SQL Server. Try using Visual Studio to connect. Upon successful connection copy that string to your configuration. My guess is the TCP ip connections are disabled on your SQL Server or someone changed the port.
|||thank you
can you teach me how to start check if the problem is from "The TCP ip connections are disabled on your SQL Server or someone changed the port. "
because I use some small program to enable to connect to MSN messenger when I'm in office , it always change my proxy into 127.0.0.1
maybe there is something been changed but I don't know..
thank you very much
|||anyone? please help.. please...
|||Hi jcjcjc,
can you teach me how to start check if the problem is from "The TCP ip connections are disabled on your SQL Server or someone changed the port. "
which version of sql server are you using? if you are using sql 2005, open sql server configuration manager (there are corresponding tools for sql express and sql 2000) and click sql server 2005 network configurateion-->Protocols for YOURSERVERNAME-->TCP/IP make sure tcp/ip connection is enabled.
Actually, i would suggest you first open your windows service list (control panel->administrational tools--> services) and see if your sql server service is started up.
Hope my suggestion helps
|||I use SQL 2000, and the weird thing is.. only this project can't connect with local DataBase
but others does...
I can't connect to http://localhost/Reports - rsinternal error
After a new installation I can't connect to http://localhost/Reports - rsinternal error
The logfiles give me the following: (haven't been able to find an answer to this issue)
<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>W. Europe Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServer__07_28_2006_11_27_56.log</Path>
<SystemName>BUIS8907-6</SystemName>
<OSName>Microsoft Windows NT 5.1.2600.0</OSName>
<OSVersion>5.1.2600.0</OSVersion>
</Header>
aspnet_wp!webserver!b0c!7/28/2006-11:27:57:: i INFO: Reporting Web Server started
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Running on 1 physical processors, 1 logical processors
aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Reporting Services starting SKU: Evaluation
aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Eval SKU: 120 days left
aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!library!b0c!07/28/2006-11:28:09:: i INFO: Call to GetPermissions:/
aspnet_wp!crypto!b0c!07/28/2006-11:28:15:: i INFO: Initializing crypto as user: BUIS8907-6\ASPNET
aspnet_wp!crypto!b0c!07/28/2006-11:28:15:: i INFO: Exporting public key
aspnet_wp!library!b0c!07/28/2006-11:28:15:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.IO.FileNotFoundException: The system cannot find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
End of inner exception stack trace
I have already tried the rsconfig -c, this was succesfully but did not resolved the issue.
hey,
I am not a expert but i had similar kind of problem initially.
http://localhost/Reportserver is a default name. Instead of localhost try putting ur database name .
like http://Database/reportserver.
ashish
|||
Thanks Ashish for your reply, but unfortunately that didn't work.
Even when I browser the virtual directory in the IIS is gives me the rsinternal error.
I found somewhere else someone who re-installed and it resolved it for them. That was the first thing I did still have the issue.
I think there must be a setting or parameter incorrect somewhere. After the installation was finished I received a message telling me that the service could not be started and I would have to manually start it. I check the service and it was running. I even restarted it. the eventviewer tells me it started successfully so.....?
Thanks again, hoping for more suggestions
sql
Subscribe to:
Posts (Atom)