Error when trying to create new databaase using SQL Server

Hi,

I have installed MS SQL server and I'm trying to create a database using the Web Matrix Project. I'm doing the following:

1. Click the Data tab in the Workspace pane.
2. Click on "Add Database Connection"
3. Select "SQL Server/MSDE Database" and click OK
4. Enter the following information:
server=localhost
Windows authentication is on
Database=somename

Click Ok

After I do all this, I get the following error:
Unable to connect to the database
SQL server does not exist or access denied.
ConnectionOpen (Connect()).

The SQL Service Manager is running with the option "Distributed Transaction Coordinator" displaying on Services. (I'm new to SQL server).

What could be causing this to happen?

Thanks a lot."Add Database Connection" is for connecting to an existing database...

use SQL Enterprise Manager to create the database first.|||1. Check if the DNS entries for the database servers are correct. These could be one of the reasons.
2. You must also see if you have sysadmin previledges to create a database.

These are some of the points that come to mind.

error when importing text file - saving in notepad first works

I'm trying to import a tab separated text file into sql server 2005 using the import guide. But when running the job I get the error message

Error 0xc02020c5: Data Flow Task: Data conversion failed while converting column "Column 19" (67) to column "Column 19" (404). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)

The column 19 which reported a problem contains this information:
?searchroot=/_gen_/txt/&template=std.htm&use=prospect&intref=1_26067

However what is mysterious is that if I open the file in notepad or Excel and resave it again the job runs perfectly. This is not a way we could make it work later on since it's an automatic job that will run each night on a new text file.

The text file is sent from Norway to Sweden - and I use ANSI latin 1 when importing.

The column has datatype DT_STR with a width of 500.

I use Locale Swedish and when I save in Notepad it is saved in ANSI,

I use Windows XP Swedish version.

Try DT_WSTR instead as its unicode.

There could be a control character in that field that gets thrown away when you save in Notepad.|||

Had the same error importing a text file. Error was resolved by changing the dataype as you advised. Thanks!

error when importing text file - saving in notepad first works

I'm trying to import a tab separated text file into sql server 2005 using the import guide. But when running the job I get the error message

Error 0xc02020c5: Data Flow Task: Data conversion failed while converting column "Column 19" (67) to column "Column 19" (404). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)

The column 19 which reported a problem contains this information:
?searchroot=/_gen_/txt/&template=std.htm&use=prospect&intref=1_26067

However what is mysterious is that if I open the file in notepad or Excel and resave it again the job runs perfectly. This is not a way we could make it work later on since it's an automatic job that will run each night on a new text file.

The text file is sent from Norway to Sweden - and I use ANSI latin 1 when importing.

The column has datatype DT_STR with a width of 500.

I use Locale Swedish and when I save in Notepad it is saved in ANSI,

I use Windows XP Swedish version.

Try DT_WSTR instead as its unicode.

There could be a control character in that field that gets thrown away when you save in Notepad.|||

Had the same error importing a text file. Error was resolved by changing the dataype as you advised. Thanks!

Error when applying a filter to a table

Table Properties, Filter Tab.
Added a filter.
Expression: =Fields!LastActionDate.Value
Operator: = Value: "7/1/2004"
Receive following when previewing report:
"An error has occured during report processing. The processing of
filter expression for the table 'table1' cannot be performed. The
comparision failed. Please check the data type returned by the data
expression."
I tried Expression: =CDate(Fields!LastActionDate.Value)
I tried removing quotes from Date value.
No Luck.
Can someone help?
Thank you!You'll also need to cast the filter Value: =CDate("7/1/2004")
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"The Whistler" <sharris@.SLeasynews.com> wrote in message
news:s6puh0pvgceg530k3sfagtefa3qogid418@.4ax.com...
> Table Properties, Filter Tab.
> Added a filter.
> Expression: =Fields!LastActionDate.Value
> Operator: => Value: "7/1/2004"
> Receive following when previewing report:
> "An error has occured during report processing. The processing of
> filter expression for the table 'table1' cannot be performed. The
> comparision failed. Please check the data type returned by the data
> expression."
> I tried Expression: =CDate(Fields!LastActionDate.Value)
> I tried removing quotes from Date value.
> No Luck.
> Can someone help?
> Thank you!
>
>

Error viewing reports

I have created a report, in SQL RS 2000, using My Windows Credentials.

ie under the datasource tab, I chose the "credentials stored securely in report server" OPTION. There I specified my user NT Credentials.

However, when I view the report, it gives me err

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source xxx. (rsErrorOpeningConnection) Get Online Help

Login failed for user xxxx

Pl advise.

Thanks.

Hello Tarana,

You need to check the box 'Use as Windows credentials when connecting to the data source' in the data source tab. Try that and see if it works.

Jarret