Got Started But Not Really: SQL Server does not allow remote connections

I downloaded VS studio express, and created a personal website using the wizard to test drive the thing. When I hit ctr + f5 to run the sample provided, then I get this message:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "

I tried disabling the firewall (Norton's firewall because Windows is disable always). Any suggestions? This is a brand-new machine, running XP sp2, just downloaded the VS studio express.

I really appreciate your inputs.

Regards,

Carlos

info@.paesano.com

Have a look at the following KB Article.

How to configure SQL Server 2005 to allow remote conections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

|||

Hi Glenn,

Thanks a lot for the answer. I followed the instructions provided in the article. Everything fine until I tried to start the SQL Express, which at the end gave me an error message: An error ocurred while performing this operation.

It seems like something is preventing SQL to start. I disabled my firewall thinking that the firewall was the cause of it, but it did not work either. If you have any suggestions, please help. As I mentioned, this is a brand-new machine running on Win SP2.

Thanks in advance.

Carlos

|||

As this looks more like a sql server express problem I will move the thread to the sql express group/

But in the mean time I would have a look at the event log for the machine to see if there are any errors being returned. With out any more details on the actuall error it is going to be hard to help.

GOOGLE Like search database

Hi,
I am planning to build a search engine which works like GOOGLE. Can anybody
send me a sample database ..
regards LaraHi
Have a look at http://www.databaseanswers.org/data_models/index.htm
or ask Google for their trade secrets.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Lara" <aneeshattingal@.hotpop.com> wrote in message
news:%23eWNoOXTFHA.2560@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am planning to build a search engine which works like GOOGLE. Can
> anybody
> send me a sample database ..
> regards Lara
>|||g*d d*mn it why don't you search google|||I have never seen Google's infrastructure, but I doubt it resembles:
http://www.databaseanswers.org/data...rch_engine.htm.
Either way, to the original question, if any of us had designed a database
to rival Googles, or even to work like theirs, don't you think we would be
out driving in our shiny new Jaguars! Seriously, this is quite a question
:)
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ON9VcdZTFHA.612@.TK2MSFTNGP12.phx.gbl...
> Hi
> Have a look at http://www.databaseanswers.org/data_models/index.htm
> or ask Google for their trade secrets.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Lara" <aneeshattingal@.hotpop.com> wrote in message
> news:%23eWNoOXTFHA.2560@.TK2MSFTNGP09.phx.gbl...
>|||You might be surprised. All their spiders do is scan web pages and extract
keywords which they slap into a database structure. The complicated piece
is their spidering logic on the application side, which has to parse HTML
tags, ignore certain words, calculate "weights" for various pages, follow
links from one page to the next, calculate references to a page, etc. I
wouldn't be surprised at all if their database structure was based on
something very simple like this, with some additional columns and/or tables
to store word occurence counts, link counts and other page ranking
information.
Like you said though, too bad we didn't think of it first! :)
"Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
news:u2CbUvoTFHA.3244@.TK2MSFTNGP15.phx.gbl...
>I have never seen Google's infrastructure, but I doubt it resembles:
>http://www.databaseanswers.org/data...rch_engine.htm.
> Either way, to the original question, if any of us had designed a database
> to rival Googles, or even to work like theirs, don't you think we would be
> out driving in our shiny new Jaguars! Seriously, this is quite a question
> :)
> --
> ----
--
> Louis Davidson - http://spaces.msn.com/members/drsql/
> SQL Server MVP
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:ON9VcdZTFHA.612@.TK2MSFTNGP12.phx.gbl...
>|||Michael, is on the right track, but Google's Architecture (see
http://www.computer.org/micro/mi2003/m2022.pdf) and search algorithm
(PageRank - see http://www.voelspriet2.nl/PageRank.pdf) is far more complex.
They do not use RDBMS (except some MySQL for minor internal support apps)
and they do not use Windows servers and the 15,000 clustered servers in the
first article, is now well over 100,000 and growing... Interesting, many
people had thought of and had done search engines, just not with their
patented PageRank algorithm and of course having your own OS and file system
and 100,000 servers and many of the top PhD's doesn't hurt as well :-).
However, even with the above said, there are still opportunities in search
that they do not handle well, i.e., Enterprise Search (or intranet search)
with combining structured search (RDBMS) and unstructured search (spiders &
html) along with local search (or desktop search) seems to me to be an
interesting possibility at this time...
Regards,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Michael C#" <xyz@.abcdef.com> wrote in message
news:hjbde.18763$V02.5438@.fe08.lga...
> You might be surprised. All their spiders do is scan web pages and
extract
> keywords which they slap into a database structure. The complicated piece
> is their spidering logic on the application side, which has to parse HTML
> tags, ignore certain words, calculate "weights" for various pages, follow
> links from one page to the next, calculate references to a page, etc. I
> wouldn't be surprised at all if their database structure was based on
> something very simple like this, with some additional columns and/or
tables
> to store word occurence counts, link counts and other page ranking
> information.
> Like you said though, too bad we didn't think of it first! :)
> "Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
> news:u2CbUvoTFHA.3244@.TK2MSFTNGP15.phx.gbl...
database
be
question
> ----
--
>|||Finally an intellignet answer to an unanswerable question... just kidding al
l.
Great response(s) though !
"Candor Feg" wrote:

> g*d d*mn it why don't you search google
>
>|||Thanks for the link - now THAT is interesting!
"John Kane" <jt-kane@.comcast.net> wrote in message
news:eZ4RkVzTFHA.1152@.tk2msftngp13.phx.gbl...
> Michael, is on the right track, but Google's Architecture (see
> http://www.computer.org/micro/mi2003/m2022.pdf) and search algorithm
> (PageRank - see http://www.voelspriet2.nl/PageRank.pdf) is far more
> complex.
> They do not use RDBMS (except some MySQL for minor internal support apps)
> and they do not use Windows servers and the 15,000 clustered servers in
> the
> first article, is now well over 100,000 and growing... Interesting, many
> people had thought of and had done search engines, just not with their
> patented PageRank algorithm and of course having your own OS and file
> system
> and 100,000 servers and many of the top PhD's doesn't hurt as well :-).
> However, even with the above said, there are still opportunities in search
> that they do not handle well, i.e., Enterprise Search (or intranet search)
> with combining structured search (RDBMS) and unstructured search (spiders
> &
> html) along with local search (or desktop search) seems to me to be an
> interesting possibility at this time...
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Michael C#" <xyz@.abcdef.com> wrote in message
> news:hjbde.18763$V02.5438@.fe08.lga...
> extract
> tables
> database
> be
> question
> --
>|||Michael,
Just curious, which link did you find interesting? (I have many others, from
my book research on this subject.)
What do you think of "Enterprise Search" or Intranet search?
Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Michael C#" <xyz@.abcdef.com> wrote in message
news:S0Bde.22739$RP1.19555@.fe10.lga...
> Thanks for the link - now THAT is interesting!
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:eZ4RkVzTFHA.1152@.tk2msftngp13.phx.gbl...
apps)
search
search)
(spiders
HTML
follow
I
would
>
-
>|||I found the architecture link the most interesting, although the Spidering
search was very informative as well. I found it very interesting how they
set up and configured their servers, as well as how they actually store
data. There definitely could be some lessons to be learned in there...
(now if I can just get my boss to hire a couple hundred developers we're on
our way! :) ) I'm particularly surprised that they don't use an RDBMS? I'm
still a little unclear on the method they use to store their data -- other
than physically separating the indexes from the data, which is pretty common
practice in SQL Server to improve performance. Do you have any more links
describing their architecture in greater detail, or do I have to wait for
the book? <g>
I had known a little bit about the page ranking formula they used, but
mostly just broad generalities. It was to see specific calculations
and formulas, and how they relate to the overall search engine scheme.
I like the enterprise search idea, but I can imagine a decent enterprise
spider and search system would require some *serious* resources to
implement. It also brings up certain aspects of privacy and security, since
it would logically - if not physically - centralize access to corporate
information. After all, they might not want Joe Schmoe in the mailroom
spidering accounting and payroll information for the top execs in the
corporation -- and they definitely don't want John Schmoe in the
competitor's mailroom pulling up corporate docs at whim.
"John Kane" <jt-kane@.comcast.net> wrote in message
news:elFuBbAUFHA.3352@.TK2MSFTNGP12.phx.gbl...
> Michael,
> Just curious, which link did you find interesting? (I have many others,
> from
> my book research on this subject.)
> What do you think of "Enterprise Search" or Intranet search?
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Michael C#" <xyz@.abcdef.com> wrote in message
> news:S0Bde.22739$RP1.19555@.fe10.lga...
> apps)
> search
> search)
> (spiders
> HTML
> follow
> I
> would
> -
>

Good Book on SQL Server Reporting Services Script

Hello, I recently discovered the rs.exe utility and .rss files. I have
looked at and enjoyed the sample scripts, but was wondering if there were any
books on this subject that anyone has found useful?
Thanks in advance!
TimTim,
That is a hard one, as all of the books out there do not talk much to the
rs.exe utility, but there is one site www.sqldbatips.com has a tool that can
help out a ton: Reporting Services Scripter.
I also have a method to debug rss scripts.
In Visual Studio
1. Create a new Visual Basic Console Application Project: name it RSDebug
2. In the Soultion Explorer window - right click on the RSDebug Project and
select the Add Web Reference option.
3. In the URL text box add:
http://servername/reportserver/reportservice2005.asmx
4. Click Go Command Button (This step takes a while)
5. In the Web Reference Name text box add SSRSWebService
6. Click Add Reference Command Button
7. In the Code Window above the Module Module1 add:
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
8. Below the Module Module1 add: Public rs As New ReportingService2005
9. Paste your script code in the Sub Main() procedure
10. Set your breakpoint and go.
Example: (In this example System.IO is needed due to the use of the
MemoryStream object)
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
Imports System.IO ' This was added because MemoryStream was used
Module Module1
Public rs As New ReportingService2005
Sub Main()
Dim strObjectName As String = "Report Name"
Dim strObjectPath As String = "/Application"
Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
Dim strLocalFile As String = "Report Name.rdl"
Dim strLocalPath As String = "C:\"
Dim strLocalFullPath As String = strLocalPath & strLocalFile
Dim objReportDefinition As Byte()
Dim objMemoryStream As MemoryStream
Dim objDocument As New System.Xml.XmlDocument()
Try
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
objMemoryStream = New MemoryStream(objReportDefinition)
objDocument.Load(objMemoryStream)
objDocument.Save(strLocalFullPath)
Console.WriteLine("Standard: Report downloaded successfully.")
Catch e As SoapException
Console.WriteLine("Error: " +
e.Detail.Item("ErrorCode").InnerText + " (" +
e.Detail.Item("Message").InnerText + ")")
End Try
End Sub
End Module|||Thanks very much Reeves, this is great information.
Tim
"Reeves Smith" wrote:
> Tim,
> That is a hard one, as all of the books out there do not talk much to the
> rs.exe utility, but there is one site www.sqldbatips.com has a tool that can
> help out a ton: Reporting Services Scripter.
> I also have a method to debug rss scripts.
> In Visual Studio
> 1. Create a new Visual Basic Console Application Project: name it RSDebug
> 2. In the Soultion Explorer window - right click on the RSDebug Project and
> select the Add Web Reference option.
> 3. In the URL text box add:
> http://servername/reportserver/reportservice2005.asmx
> 4. Click Go Command Button (This step takes a while)
> 5. In the Web Reference Name text box add SSRSWebService
> 6. Click Add Reference Command Button
> 7. In the Code Window above the Module Module1 add:
> Imports RSDebug.SSRSWebService
> Imports System.Web.Services.Protocols
> 8. Below the Module Module1 add: Public rs As New ReportingService2005
> 9. Paste your script code in the Sub Main() procedure
> 10. Set your breakpoint and go.
>
> Example: (In this example System.IO is needed due to the use of the
> MemoryStream object)
>
> Imports RSDebug.SSRSWebService
> Imports System.Web.Services.Protocols
>
> Imports System.IO ' This was added because MemoryStream was used
>
> Module Module1
> Public rs As New ReportingService2005
>
> Sub Main()
> Dim strObjectName As String = "Report Name"
> Dim strObjectPath As String = "/Application"
> Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
> Dim strLocalFile As String = "Report Name.rdl"
> Dim strLocalPath As String = "C:\"
> Dim strLocalFullPath As String = strLocalPath & strLocalFile
> Dim objReportDefinition As Byte()
> Dim objMemoryStream As MemoryStream
> Dim objDocument As New System.Xml.XmlDocument()
>
> Try
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
> objMemoryStream = New MemoryStream(objReportDefinition)
> objDocument.Load(objMemoryStream)
> objDocument.Save(strLocalFullPath)
> Console.WriteLine("Standard: Report downloaded successfully.")
> Catch e As SoapException
> Console.WriteLine("Error: " +
> e.Detail.Item("ErrorCode").InnerText + " (" +
> e.Detail.Item("Message").InnerText + ")")
> End Try
> End Sub
> End Module|||On Aug 7, 7:58 pm, TimS <timsts...@.msn.com(donotspam)> wrote:
> Thanks very much Reeves, this is great information.
> Tim
> "Reeves Smith" wrote:
> > Tim,
> > That is a hard one, as all of the books out there do not talk much to the
> > rs.exe utility, but there is one sitewww.sqldbatips.comhas a tool that can
> > help out a ton: Reporting Services Scripter.
> > I also have a method to debug rss scripts.
> > In Visual Studio
> > 1. Create a new Visual Basic Console Application Project: name it RSDebug
> > 2. In the Soultion Explorer window - right click on the RSDebug Project and
> > select the Add Web Reference option.
> > 3. In the URL text box add:
> >http://servername/reportserver/reportservice2005.asmx
> > 4. Click Go Command Button (This step takes a while)
> > 5. In the Web Reference Name text box add SSRSWebService
> > 6. Click Add Reference Command Button
> > 7. In the Code Window above the Module Module1 add:
> > Imports RSDebug.SSRSWebService
> > Imports System.Web.Services.Protocols
> > 8. Below the Module Module1 add: Public rs As New ReportingService2005
> > 9. Paste your script code in the Sub Main() procedure
> > 10. Set your breakpoint and go.
> > Example: (In this example System.IO is needed due to the use of the
> > MemoryStream object)
> > Imports RSDebug.SSRSWebService
> > Imports System.Web.Services.Protocols
> > Imports System.IO ' This was added because MemoryStream was used
> > Module Module1
> > Public rs As New ReportingService2005
> > Sub Main()
> > Dim strObjectName As String = "Report Name"
> > Dim strObjectPath As String = "/Application"
> > Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
> > Dim strLocalFile As String = "Report Name.rdl"
> > Dim strLocalPath As String = "C:\"
> > Dim strLocalFullPath As String = strLocalPath & strLocalFile
> > Dim objReportDefinition As Byte()
> > Dim objMemoryStream As MemoryStream
> > Dim objDocument As New System.Xml.XmlDocument()
> > Try
> > rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> > objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
> > objMemoryStream = New MemoryStream(objReportDefinition)
> > objDocument.Load(objMemoryStream)
> > objDocument.Save(strLocalFullPath)
> > Console.WriteLine("Standard: Report downloaded successfully.")
> > Catch e As SoapException
> > Console.WriteLine("Error: " +
> > e.Detail.Item("ErrorCode").InnerText + " (" +
> > e.Detail.Item("Message").InnerText + ")")
> > End Try
> > End Sub
> > End Module
I ordered Microsoft's new books for the MCITP certification program in
Business Intelligence. One covers the 70-445 exam and the other one
the 70-446 exam. I'm sure you'll find them very useful (once they're
published anyways!).
http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-445/dp/0735623414/ref=pd_bbs_1/102-9922975-8902553?ie=UTF8&s=books&qid=1186575878&sr=8-1
http://www.amazon.com/MCITP-Self-Paced-Training-Exam-70-446/dp/0735623848/ref=pd_bbs_2/102-9922975-8902553?ie=UTF8&s=books&qid=1186575878&sr=8-2

Global connection string?

A sample connection string is something like this...

"Server=sql.company.com;Database=myDatabase;Trusted_Connection=True;"

My question is, since the actual .com must go into the string, if you change host companies,
you will have to go through all pages and also change the connection string.

I know there must be a way to declare the string once in like the global.asax and then
refer each page to that string.

I've been hunting around for a sample on how to do this.

Anyone know a good link to refer to?

Thanks,

ZathNever mind all, I forgot about putting it in a class... DOH...

Sorry to waste anyones time...

Zath|||Hi Zath,

There are obviously many ways of doing this. A method I make use of is to declare a connection string variable in global.asax and call it anywhere I need it within the current project.

The declaration is done this way:

Public Shared connString as String = "your parameters"

Calling this is done this way:

Global.connString

I hope this helps.