Flight Sample Debate

Hi All,

I found the Flight Sample Description at http://msdn2.microsoft.com/en-us/library/ms160946(d=ide).aspx .

I installed the file SQLServerSamples.msi which is in C:\Program

Files\Microsoft SQL Server\90\Tools\Samples by default.

I followed the steps strictly.

Every thing was OK except:

- I didn't have any response in the Notifications folder which by

default resides in C:\Program Files\Microsoft SQL Server\90\Samples\Notification

Services\Flight

- I didn't understand what happened exactly

So:

- What are the probable causes of not getting a result?

- I want some documentation about what happens in the example.

Thanks in advance,

Bishoy

Anything in the Event Viewer?

Try turning on Verbose logging to see if that helps point you in the right direction.

|||

1- That all what is found in Event Viewer:

Event Type: Information
Event Source: Service Control Manager
Event

Category: None
Event ID: 7035
Date: 8/11/2006
Time: 6:13:43

PM
User: BISHOYLAPTOP\Bishoy
Computer: BISHOYLAPTOP
Description:
The

NS$FlightInstance service was successfully sent a start control.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

> but still there is nothing appeared in the Notifications Folder

2- What is Verbose login

3- I want documentation source about that Flight Sample.

Thank you.

Bishoy

|||

I found where the error was:

There should be one strong name key for both the

AddSubscribers and AddSubscription projects.

The signing for both projects is ..\..\..\SampleKey.snk which I could never

make myself.

Now I have the following questions or inquires:

1- I want some documentations about what happened in that example.

2- How to sign a project to present key in above folder like

..\..\..\SampleKey.snk (because browse button copy the key to the project

folder)?

3- What is the output meaning in the Notifications folder which is

FileNotifications.txt file?

Many Thanks and Best Regards.

Bishoy

|||

Hi Bishoy -

Rather than continuing with two parallel conversations, I've posted replies to the NewsGroup.

http://groups.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_frm/thread/24e8f2b998118394/013718ab4d063ff3?hl=en#013718ab4d063ff3

HTH...

Joe

Flat file source not option for importing data

I was getting the product error associated with the full version of SSIS not installed so I ran the installation again and selected the Integration Services check box.

Now when attempting to import data into a database, the drop down list doesn't have a flat file option.

How do I import data from a txt, csv file?

Thanks

PatrickCrofoot@.hotmail.com

did you stop and restart Integration Services? is it running under a domain administrator account?|||I have. And no..

Simply using SQL Server Management Studio and right clicking my db then choosing import data under tasks. There is no Flat File datasource.

So the other route was to attempt the tutorial via integration services. That's when I get the more descriptive error that the FLATFILE option is not installed correctly.

I've completely un-installed and re-installed SQL Server 2005 and all associated tools. Same problem.
|||I'm having the exact same problem. I'm about to install CTP SP1 to see if it corrects the problem.|||I uninstalled and re-installed the complete application.... twice.. And now it seems to work. Nothing to do with SP1.

Flat file source not option for importing data

I was getting the product error associated with the full version of SSIS not installed so I ran the installation again and selected the Integration Services check box.

Now when attempting to import data into a database, the drop down list doesn't have a flat file option.

How do I import data from a txt, csv file?

Thanks

PatrickCrofoot@.hotmail.com

did you stop and restart Integration Services? is it running under a domain administrator account?|||I have. And no..

Simply using SQL Server Management Studio and right clicking my db then choosing import data under tasks. There is no Flat File datasource.

So the other route was to attempt the tutorial via integration services. That's when I get the more descriptive error that the FLATFILE option is not installed correctly.

I've completely un-installed and re-installed SQL Server 2005 and all associated tools. Same problem.
|||I'm having the exact same problem. I'm about to install CTP SP1 to see if it corrects the problem.|||I uninstalled and re-installed the complete application.... twice.. And now it seems to work. Nothing to do with SP1.

Fit-to-page printing

How can I print reports to be fit-to-page. I have SP2 installed.
Are there any scripting or external assembly solutions ?
--
KolithaI have the same problem. I haven't installed SP yet...
Does anyone know how to do that?
Thanks
Chieko
"Kolitha de Silva" wrote:
> How can I print reports to be fit-to-page. I have SP2 installed.
> Are there any scripting or external assembly solutions ?
> --
> Kolitha

First time setting up SQL MSDE, trouble loggin in...

I just installed MSDE and I am getting errors when trying to install the Time Tracker application: "Unable to connect" and my only option is to cancel the installation.

I also get an error when trying to connect using Web Data Administrator: "Invalid username and/or password, or server does not exist. Also, please ensure that SQL Server Authentication is enabled on the server. " I am using the "sa" account with the correct password. I have also tried no password (just in case) and that doesn't work either.

I cannot confirm that I have SQL Server Authentication enabled. I have no idea how to check for this using SQL MSDE. This may be part of the problem...any thoughts on this issue?

My OS: Windows XP Professional Service Pack 1 (Build 2600)

My Web Server: Internet Information Services Version 5.1.2600.0

My .NET Framework: .NET Framework Version 1.1.4322.573

My SQL Server: Microsoft SQL Server Desktop Engine (SQL Server Version 8.00.760)

Other Info: .NET is fine and linked to IIS, all other .NET apps compile/run fine. SQL Server Service Manager is giving me the green arrow. My OS is MS WinXP Pro, all SP's and hot fixes and updates applied.

I will be monitoring this post and trying any suggestions right away & posting my success/failure right back here.

If anyone would like to see a screen shot of the error generated by the Time Tracker install, use the following link:

http://www.versyss.com/mike/shot.gif

Thanks in advance!First, to determine with authentication mode you are using, go to the Windows command prompt and type this command:

osql -d Master -Q "xp_loginconfig" -E

Terri|||Results of: osql -d Master -Q "xp_loginconfig" -E

Name: Config_Value
--------
login mode:Windows NT Authentication
default login:guest
default domain:Null
audit level:none
set hostname:false
map _ :domain separator
map $:Null
map #:-

So it looks like I am using Win. NT Auth. mode. Now how do I switch this to SQL Server Auth. or Mixed Mode? Remember this is a MSDE installation so I have no Enterprise Manager...

Thanks sof the help so far....Mike|||Without Enterprise Manager, you could edit the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer

Change LoginMode to 1 for "Windows Only", 2 for "SQL Server and Windows"

As always, use care when editing the registry. It should be backed up first. If you've never edited the registry, you should read up on it first. I claim no responsibility!

Terri|||Terri, you RULE!

It worked. I edited the reg value you indicated, rebooted, ran "osql -d Master -Q "xp_loginconfig" -E" and verified my mode (which now reads "mixed") and was able to log into my server using Web Data Admin! Thanks so much! I hope this posts helps some other people as well!

P.S. The use of "localhost" didn't work for the server. I think I read somewhere that the "localhost" option has been disabled in MSDE. I don't know for sure but all I know is that "localhost" didn't work for me but the server name and IP address do...

Thanks again Terri...

First Time Installing - Can't Find BIDS

Thank you to all that take the time to read this!

All software is installed on a single development pc.I have a SQL Server 2000 Developer Edition Database that I am using to test a new Accounting System.SQL Server 2000 is the required format.I would like to start developing some SRSS reports against that database.It was suggested that I install the SQL Server 2005 Reporting Services, because I was told 2005 is less buggy and easier to use.I installed SRSS 2005, and only SRSS 2005, and used the Configuration Tool to get it configured properly, I think. I have green checks on everything except "Email Settings" and "Execution Account"

Now, I want to write some reports.BIDS is not under the "Microsoft SQL Server 2005" program group, only "Configuration Tools".I was also told that I could use Visual Studio to write reports.I installed Visual Studio 2005 Standard Edition.When I go start a new project, "Business Intelligence” is not a project type or sub-type.

What do I need to do so I can either install BIDS or use VS 2005 to write reports?

If you open Visual Studio 2005 and create a new project, do you see 'Business Intelligence Projects' as an available project type?

Jarret

|||

BIDS is part of the SQL Server 2005 Workstation components and development tools - you'll need to go back and install that option in the installer.

Installing BIDS includes the SSRS support in Visual Studio. (BIDS actually is Visual Studio, just with little/no programming language support by default.)

|||

Rup,

Thank you for the help! That was the problem.

First Steps: Any Chance of Upgrading VS 2005 Express to SQL 2005 Server?

Hello,

Thanks for reviewing my question. I have installed VisualStudio 2005 on a computer and would like to know if I can install SQL 2005 Server and replace the SQL Express version? Will VS recognize it?

Many Thanks to the Experts

Peter

VS2005 can access either version of SQL server.|||Yes, I've used sql express and sql 2005 on the same machine, and I use sql express (local) and remote sql server 2000 at the office. VS2005 had no problem with either situation.

firewalls? port numbers? ancient curses cast upon my servers?

Hello All,
Hopefully someone has come across this...

I have the client side of my application installed in the US,
with the application and the database servers running in london.

The program language is C#, all built in .net, with the .net installer.
When the user in the US runs the program and it gets to the
import progress part (background processing occurring on London servers),
they are getting no feedback as to the progress of the import.
ie, nothing is being sent to the US from the london server.
But everything runs smooth the other way, ie, tables are written to
the sql db's in london etc... And I get data sending and receiving
here in london when i run the client app on my machine and send to
the servers here, so its some problem with the connection with the US....
firewalls? port numbers? ancient curses cast upon my servers?

Cheers mike

Is this using SQL Server Integration Services (the SQL Server 2005 replacement for DTS)?
(In any case, if the "import" part isn't giving feedback, you probably should investigate the "import" part, to see what it does, and revise it to give feedback -- it may be hard for anyone here to know what this "import" part is -- if you suspect a connection problem, network sniffing, or even simple use of sysinternals tcpview may be helpful.)

firewalls? port numbers? ancient curses cast upon my servers?

Hello All
I have the client side of my application installed in the US, with the
application and the database servers running in london.
The program language is C#, all built in .net, with the .net installer. When
the user in the US runs the program and it gets to the import progress part
(background processing occurring on London servers), they are getting no
feedback as to the progress of the import. ie, nothing is being sent to the
US from the london server. But everything runs smooth the other way, ie,
tables are written to the sql db's in london etc... And I get data sending
and receiving here in london when i run the client app on my machine and send
to the servers here, so its some problem with the connection with the US...
firewalls' port numbers' ancient curses cast upon my servers' anyone come
across anything like this?
Cheers mikeHave you tested access with Query Analyzer to see if you can connect, access
the database from both places and perform the import tasks? It's unclear
from your post whether you're just having problems with the import task or
if it's even connecting.
joe.
"blomm via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:54B0800E732D8@.SQLMonster.com...
> Hello All
> I have the client side of my application installed in the US, with the
> application and the database servers running in london.
> The program language is C#, all built in .net, with the .net installer.
> When
> the user in the US runs the program and it gets to the import progress
> part
> (background processing occurring on London servers), they are getting no
> feedback as to the progress of the import. ie, nothing is being sent to
> the
> US from the london server. But everything runs smooth the other way, ie,
> tables are written to the sql db's in london etc... And I get data
> sending
> and receiving here in london when i run the client app on my machine and
> send
> to the servers here, so its some problem with the connection with the
> US...
> firewalls' port numbers' ancient curses cast upon my servers' anyone
> come
> across anything like this?
> Cheers mike|||"It's unclear
from your post whether you're just having problems with the import task or
if it's even connecting."
Sorry, i will try and clarify:
it is connecting, theres problems with the callback functionality i think, if
that means anything to you.
okay, thanks for your pointers, i'm off to follow them up.
m

Firewall Setting for XP Professional

We have installed SQL Server Evaluation copy on a Windows
XP Professional Workstation with SP2 installed. We also
installed Reporting Services on that workstation as well.
We would like to access the reports on that workstation
from a remote workstation. In this way, we would like to
know what is the best way to open the firewall ? Is it
only for us to add C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\sqlservr.exe in the exception list ?
ThanksHi
http://support.microsoft.com/?kbid=841249
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel" wrote:
> We have installed SQL Server Evaluation copy on a Windows
> XP Professional Workstation with SP2 installed. We also
> installed Reporting Services on that workstation as well.
> We would like to access the reports on that workstation
> from a remote workstation. In this way, we would like to
> know what is the best way to open the firewall ? Is it
> only for us to add C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\sqlservr.exe in the exception list ?
> Thanks
>
>

Firewall Setting for XP Professional

We have installed SQL Server Evaluation copy on a Windows
XP Professional Workstation with SP2 installed. We also
installed Reporting Services on that workstation as well.
We would like to access the reports on that workstation
from a remote workstation. In this way, we would like to
know what is the best way to open the firewall ? Is it
only for us to add C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\sqlservr.exe in the exception list ?
Thanks
Hi
http://support.microsoft.com/?kbid=841249
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel" wrote:

> We have installed SQL Server Evaluation copy on a Windows
> XP Professional Workstation with SP2 installed. We also
> installed Reporting Services on that workstation as well.
> We would like to access the reports on that workstation
> from a remote workstation. In this way, we would like to
> know what is the best way to open the firewall ? Is it
> only for us to add C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\sqlservr.exe in the exception list ?
> Thanks
>
>

Firewall Setting for XP Professional

We have installed SQL Server Evaluation copy on a Windows
XP Professional Workstation with SP2 installed. We also
installed Reporting Services on that workstation as well.
We would like to access the reports on that workstation
from a remote workstation. In this way, we would like to
know what is the best way to open the firewall ? Is it
only for us to add C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\sqlservr.exe in the exception list ?
ThanksHi
http://support.microsoft.com/?kbid=841249
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel" wrote:

> We have installed SQL Server Evaluation copy on a Windows
> XP Professional Workstation with SP2 installed. We also
> installed Reporting Services on that workstation as well.
> We would like to access the reports on that workstation
> from a remote workstation. In this way, we would like to
> know what is the best way to open the firewall ? Is it
> only for us to add C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\sqlservr.exe in the exception list ?
> Thanks
>
>

Firewall Port 1443

I installed SQL Server 2000 Enterprise Trial. I am trying to connect to my Remote database. In Enterprise Manager it won't resolve listing the server and it's tables. I can register and get a connection though. My host said that if I am behind the firewal
l, that it blocks Port 1433. I tried switching the Port to 8080 and 1222. Still no luck. I am stuck. Any ideas?
Stickfigure
Because everyone likes Figures.
can you connect using query analyser? Or osql?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||If it is a firewall issue, and if port 1433 is blocked then the chances are
that ports 8080 and 1222 are blocked also. You might need to take this up
with your firewall administrator.
"Stickfigure" <Stickfigure@.discussions.microsoft.com> wrote in message
news:792F6F89-F318-4E47-99FA-189E9D082BDD@.microsoft.com...
>I installed SQL Server 2000 Enterprise Trial. I am trying to connect to my
>Remote database. In Enterprise Manager it won't resolve listing the server
>and it's tables. I can register and get a connection though. My host said
>that if I am behind the firewall, that it blocks Port 1433. I tried
>switching the Port to 8080 and 1222. Still no luck. I am stuck. Any ideas?
> Stickfigure
> Because everyone likes Figures.

Firewall Port 1443

I installed SQL Server 2000 Enterprise Trial. I am trying to connect to my Remote database. In Enterprise Manager it won't resolve listing the server and it's tables. I can register and get a connection though. My host said that if I am behind the firewal
l, that it blocks Port 1433. I tried switching the Port to 8080 and 1222. Still no luck. I am stuck. Any ideas?
Stickfigure
Can you connect through query analyser to another machine?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Firewall Port 1443

I installed SQL Server 2000 Enterprise Trial. I am trying to connect to my R
emote database. In Enterprise Manager it won't resolve listing the server an
d it's tables. I can register and get a connection though. My host said that
if I am behind the firewal
l, that it blocks Port 1433. I tried switching the Port to 8080 and 1222. St
ill no luck. I am stuck. Any ideas?
StickfigureCan you connect through query analyser to another machine?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Firewall Port 1443

I installed SQL Server 2000 Enterprise Trial. I am trying to connect to my R
emote database. In Enterprise Manager it won't resolve listing the server an
d it's tables. I can register and get a connection though. My host said that
if I am behind the firewal
l, that it blocks Port 1433. I tried switching the Port to 8080 and 1222. St
ill no luck. I am stuck. Any ideas?
Stickfigure
Because everyone likes Figures.can you connect using query analyser? Or osql?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||If it is a firewall issue, and if port 1433 is blocked then the chances are
that ports 8080 and 1222 are blocked also. You might need to take this up
with your firewall administrator.
"Stickfigure" <Stickfigure@.discussions.microsoft.com> wrote in message
news:792F6F89-F318-4E47-99FA-189E9D082BDD@.microsoft.com...
>I installed SQL Server 2000 Enterprise Trial. I am trying to connect to my
>Remote database. In Enterprise Manager it won't resolve listing the server
>and it's tables. I can register and get a connection though. My host said
>that if I am behind the firewall, that it blocks Port 1433. I tried
>switching the Port to 8080 and 1222. Still no luck. I am stuck. Any ideas?
> Stickfigure
> Because everyone likes Figures.