Not A Trusted Connection

I set up my SQLExpress server using Windows Authentication only. Now when I
try to create a user account using Username and Password, the connection
returns the error: Not a trusted connection. Does this have something to do
with my previous server setup or is there a general setting somewhere I need
to change?
Regards,
Fred Chateau
http://hotelmotelnow.com
Never mind... I found the setting.
Regards,
Fred Chateau
http://hotelmotelnow.com
"Fred Chateau" <webmaster@.hotelmotelnow.com> wrote in message
news:u323BNenHHA.588@.TK2MSFTNGP06.phx.gbl...
>I set up my SQLExpress server using Windows Authentication only. Now when I
>try to create a user account using Username and Password, the connection
>returns the error: Not a trusted connection. Does this have something to do
>with my previous server setup or is there a general setting somewhere I
>need to change?
> --
> Regards,
> Fred Chateau
> http://hotelmotelnow.com
>

Not A Trusted Connection

I set up my SQLExpress server using Windows Authentication only. Now when I
try to create a user account using Username and Password, the connection
returns the error: Not a trusted connection. Does this have something to do
with my previous server setup or is there a general setting somewhere I need
to change?
Regards,
Fred Chateau
http://hotelmotelnow.comNever mind... I found the setting.
Regards,
Fred Chateau
http://hotelmotelnow.com
"Fred Chateau" <webmaster@.hotelmotelnow.com> wrote in message
news:u323BNenHHA.588@.TK2MSFTNGP06.phx.gbl...
>I set up my SQLExpress server using Windows Authentication only. Now when I
>try to create a user account using Username and Password, the connection
>returns the error: Not a trusted connection. Does this have something to do
>with my previous server setup or is there a general setting somewhere I
>need to change?
> --
> Regards,
> Fred Chateau
> http://hotelmotelnow.com
>

Noob: SQLEXPRESS_ADV Full-Text Disabled

Some background:
I initially installed SQLEXPRESS (without advanced services) as my default
instance. I read that Full-Text was not supported in that version, so I
disabled the Service, and downloaded and installed Advanced as a named
instance.
The "Use full-text indexing" checkbox on the Files tab of the Database
Properties dialog is disabled.
Attempting to create a new database is no different, the same disabled
checkbox on the Files tab.
Attempting to use SQL results in the error:
CREATE FULLTEXT CATALOG catFullText
Msg 7609, Level 17, State 100, Line 1
Full-Text Search is not installed, or a full-text component cannot be
loaded.
Any ideas? Should I completely uninstall everything and start over
correctly?
~Todd
Hi Todd, can you check to see if the MSFETSQL is installed and running?
Check it from a command prompt by typing net start and look for something
like this
SQL Server FullText Search (SQLEXPRESS)
Where SQLExpress is the name of your SQL Express instance.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Todd Bollack" <webdevtool@.gmail.com> wrote in message
news:OWiBUTUCHHA.4292@.TK2MSFTNGP06.phx.gbl...
> Some background:
> I initially installed SQLEXPRESS (without advanced services) as my default
> instance. I read that Full-Text was not supported in that version, so I
> disabled the Service, and downloaded and installed Advanced as a named
> instance.
> The "Use full-text indexing" checkbox on the Files tab of the Database
> Properties dialog is disabled.
> Attempting to create a new database is no different, the same disabled
> checkbox on the Files tab.
> Attempting to use SQL results in the error:
> CREATE FULLTEXT CATALOG catFullText
> Msg 7609, Level 17, State 100, Line 1
> Full-Text Search is not installed, or a full-text component cannot be
> loaded.
>
> Any ideas? Should I completely uninstall everything and start over
> correctly?
> ~Todd
>